View Single Post
 
Old 11-01-2013, 09:33 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I've only recently graduated from Excel 2003 to 2010, so I haven't yet tried the "remove duplicates" feature. But the way I'd get a count is this:

1) Sort on the server name.

2) In a column somewhere to the right—say X—make a simple formula: "A2=A1".

That's assuming the server name is in column A; use whichever column is appropriate. It's also assuming that there's one header row at the top, that the server names start in row 2. Now column X has a series of True and False values; it's False wherever the server name is not identical to the one above it (in other words this is a new server), and True if it's the same. All the Trues are duplicate, you see. So:

3) At the bottom of column X, use a COUNTIF function to count the False values, something like "=COUNTIF(X2:X62294,FALSE)".

How's that?
Reply With Quote