Try this:

D2 = apost
D3 = fone

Enter this array formula** in E2 and copy down as needed:

=COUNT(1/FREQUENCY(IF(Store=D2,MATCH(Order,Order,0)),ROW(Or der)-MIN(ROW(Order)+1)))

Biff

"Chris K" wrote in message
...
I have a list of stores with many order numbers, the order numbers are
duplicated. I need to count the unique number of order numbers according
to
each store without manually removing duplicates etc. within excel 2007.
e.g.
Store Order Number
apost 100124
apost dave101
apost dave101
apost 100024
fone 115
fone 1000214
fone lar1004
fone 1000214
fone 10021

Result
apost 3
fone 4

--
Chris K
Excel user