I would like excel to count a range of cells and return the number of different values.
For example, if the below values were in ceels which made up the range, then the number of different values would be 3. FSG00326 appears in 2 cells but is only counted once as it only constitutes one value.
FSG00326
FSG00326
FSG00295
FSG00842
Does anyone know how to do this in 2003?
Thanks
Bookmarks