Do you need the entire Column--from A1 all the way to A65536? Or, do you just
need the formula to always account for the all the entries in Column A?
I might be misremebering, but I don't believe that MATCH can accept an
entire Column as an argument.

If all the Numbers are in a contiguous range (no blanks Rows), then you can
do the following:
1. Click on cell A1 (the first cell in the range)
2. Insert | Name | Define
3. Type MyRange for the Name: (no spaces)
4. Then, in the Refers to line, type this:
=OFFSET(Sheet8!$A$1,0,0,COUNTA(Sheet8!$A:$A))
5. Then, try this formula (a modification of the one Domenic posted:
=SUM(IF(FREQUENCY(IF(myrange<"",MATCH(myrange,myr ange,0)),IF(myrange<"",MATCH(myrange,myrange,0))) 0,1,0))

Make sure you enter it with Ctrl+Shift+Enter.
You may need to copy the formula to a text editor (like Notepad) to make
sure you get it all on one line and don't have any spaces at the end of it.
Then, copy from the text editor to Excel. Double_click on the cell, and then
press Ctrl+Shift+Enter.

If you have blank rows in the data list, this formula may not return the
correct result.


tj