Hi
I have a list of names in column B2:B1394, along with other data in adjacent columns.
After filtering the data from the adjacent columns, how do I then return the number of unique names in column B (ideally using a non-array formula).
I have previously used:
=SUMPRODUCT((B2:B1394<>"")/COUNTIF(B2:B1394,B2:B1394))
But this does not work once the list is filtered.
I am using Excel 2003 if that makes a difference.
Many thanks in advance.
Bookmarks