Problem with Count

[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

 

[Jerry W. Lewis]

=SUM(1/COUNTIF(A1:A7,A1:A7))

array entered (Ctrl-Shift-Enter).

Jerry