J
John Hayden
Fairly new to this so hope someone can help
On work sheet in A:A have row of numbers some of
which are the same.
How can I count the number of different numbers in
the column and then have the result posted in a cell
Is there one formula I can put in this cell that will do
this count for me?
eg
A:A
117 Number of Different Numbers = 5
116
117
873
982
115
117
Any assistance gratefully received
John
On work sheet in A:A have row of numbers some of
which are the same.
How can I count the number of different numbers in
the column and then have the result posted in a cell
Is there one formula I can put in this cell that will do
this count for me?
eg
A:A
117 Number of Different Numbers = 5
116
117
873
982
115
117
Any assistance gratefully received
John