Counting Unique Values with Multiple Criteria

PLEASE HELP! i have been working on this for days

I need to find the number of Unique Customer accounts associated with certain criterias......


For example i need to see how many see how many unique customer Id's have bougth form us if OEM NAme is "1" The Team is "LOB",the Date entered is "PRE" and the status is "PO"

Mind you i have 222,222 Rows i am working with


Status Data Entered OEM Name Teams Company ID
PO PRE 1 LOB 55
NS POST 5 Tournoux 66
RTN PRE 6 Balsdeasari 55
NS POST 9 LOB 88
PO PRE 8 Tournoux 99
NS POST 7 Balsdeasari 2
RTN POST 4 LOB 8
NS PRE 1 Tournoux 4
PO POST 3 Balsdeasari 9
NS PRE 10 LOB 17
RTN POST 11 Tournoux 1458
NS POST 2 Balsdeasari 9
PO PRE 6 Balsdeasari 408
NS POST 6 LOB 446
RTN PRE 7 Tournoux 485
NS POST 7 Balsdeasari 524
PO POST 7 LOB 563
NS PRE 7 Tournoux 601
RTN POST 7 Balsdeasari 640
NS PRE 7 Balsdeasari 679
PO POST 7 LOB 718
NS POST 7 Tournoux 756
RTN PRE 8 Balsdeasari 795
NS POST 8 LOB 834
PO PRE 8 Tournoux 873
NS POST 8 Balsdeasari 911
RTN POST 8 Balsdeasari 950
NS PRE 8 LOB 989
PO POST 8 Tournoux 1028
NS PRE 8 Balsdeasari 1066
RTN POST 9 LOB 1105
NS POST 9 Tournoux 1144
PO PRE 9 Balsdeasari 1183
NS POST 9 Balsdeasari 1221
RTN PRE 9 LOB 1260
NS POST 9 Tournoux 1299
PO POST 9 Balsdeasari 1338
NS PRE 9 LOB 1376

Might be interesting to check if a UDF is faster over such a huge range.Example in attachment just covers the data from post #1.

i would really liek to keep this to a Formula but i am still having a hard time get it just right. i haver attached what would be the basic format for the finall report maybe this will help with the formula

[atch]Book2[/attach]

here is the attachment.. i thnak youy for all your help ...new to this !

Unfortunalely there will actually be many duplicates, but i can trim the rows down to about 90,000... you think that might help?

I got it ot work with a smaller amount of Data but with the amount i am using it just Crashes Excell ..... i will have to use Pivot Tables i guess. Thank you So much for all your help !!!!!!!!!!!!!!!!!!