I have an excel spread sheet that contains a list of server names in column B. The server names appear multiple times in this column.
I would like to count the number of unique server names in a give range.
The range is B2:B1400
I tried this but it returned 0
=SUM(IF(FREQUENCY(B2:B1400,B2:B1400)>0,1))
Would someone know how?
Answer
FREQUENCY doesn't work like that.
One of the quickest ways to get the distinct count would be to first filter out the duplicates and then select the records, right-click on bottom bar of Excel and check 'Count'.
See this post for getting the distinct values in Excel.
UPDATE: There are a bunch of ways you could achieve this.. http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/
No comments:
Post a Comment