Unquie Value Count In Multiple Column Range

  • Thread starter Thread starter bdaoust
  • Start date Start date
B

bdaoust

I have four columns that look like :

1B9H 2B1H 2B3H 2B3H
1B9I 2B1I 2B3I 2B3I
1B9J 2B1J 2B3J 2B3J
1B9N 2B1N 2B3N 2B3N
1B9P 2B1P 2B3P 2B3P
1B9Q 2B1Q 2B3Q 2B3Q
1B9R 2B1R 2B3R 2B3R
1B9X 2B1X 2B3X 2B3X
1B9T 2B1T 2B3T 2B3T

I need a formula to count the unquie occurances in a range.

I tried the examples out there, but it looks as though the range in
the examples only account for one column. I need to be able to do it
for multiple columns (4 in the example above) Also, due to formaating
of the workbook I'm using, I need to be able to account for blank
colums/cells/etc.

Thanks in advance!
 
Hello,

I'm not sure that I have understood what you mean with blank
colums/cells/etc.

A formula that could help you:

I assumed your data are in A1 to D9
the array formula is :
=SUM(--(COUNTIF($A$1:$D$9,A1:D9)=1))

This is an array formula. You should validate this formula with the
combination of the three keystrokes CTRL+SHIFT*ENTER instead of using
the single keystroke ENTER. The formulas will be surrounded by braces.





_____________________________________________
 
Back
Top