Counting different values within a column
Posted by Andrew Cooke on December 13, 2000 6:41 AM
Apoligies to all for the simplicity of the query but although I use Excel I don't use formulas that often.
A column of data eg 1,2,2,3,5,5 If I use try to use "count" formula I get an answer of 6, which is right but I want to count the number of different values ie 1 2 3 & 5 to give an answer of 4 !
All suggestions gratefully accepted, thanks in advance