Single Cell Formula to get unique count from 1 column based on 4 other columns

[aalim95]

Hi,

I have a set of data where Columns B thru E contain records that repeats many times - each time they are repeated with a unique ID.

I need a single cell formula that will look at the criteria provided and then give me the number of unique ID's (in Column A) that are associated to my criteria.

More details are in my attached file.

Any help would be highly appreciated...….you guys are awesome!!!

thanks

[Phuocam]

Try this:

=SUM(IF((B3:$B$28524=H5)*(C3:$C$28524=I5)*(D3:$D$28524=J5)*(E3:$E$28524=K5),
1/COUNTIFS(A3:$A$28524,A3:$A$28524,B3:$B$28524,H5,C3:$C$28524,I5,D3:$D$28524,J5,E3:$E$28524,K5)))

Enter with Ctrl+Shift+Enter.

[bebo021999]

Try:

Please Login or Register  to view this content.

Array formula, confirmed with Ctrl-shift-enter.

[aalim95]

Fantastic!! thanks guys....it worked like a charm thank you SOO MUCH!!!