If not, you can try another method, assume the accounts are in A2:A1000 with
a header in A1, select
A1:A1000 by typing A1:A1000 in the namebox and pressing enter, do
datafilteradvanced filter,
make sure not to select more than the range of accounts if you have adjacent
cells with data.
Select unique records only and copy to another location, assume you copy to
F1, now in G2 (first adjacent cell to the accounts since F1 is the header)
put

=COUNTIF($A$2:$A$1000,F2)


copy down, that will give a list with unique account names/numbers with
their count

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Peo Sjoblom" wrote in message
...
So you want a distinct count of all the accounts like

12345
12345
67891

would count as 2?

If so

=SUMPRODUCT(--(A1:A250<""),1/COUNTIF(A1:A250,A1:A250&""))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"anniejhsu" wrote
in message ...

Thanks for the help. Unfortunately, there are hundreds of unique account
ID numbers in this column, so using countif for each of them wouldn't
work. Is there any way to determine this information without having to
name the actual account ID in the formula?

Thanks,
Annie


--
anniejhsu
------------------------------------------------------------------------
anniejhsu's Profile:
http://www.excelforum.com/member.php...o&userid=34961
View this thread:
http://www.excelforum.com/showthread...hreadid=546966