CODEWITHSUNDEEP
excel-formuladuplicates
Luis
Luis

Reputation: 13

Duplicates and sorting

My table updated See if this picture of my table helps understand what I am trying to do. Thank you. B1 is where I am trying to return the column C count. I do have some duplicates in column B (as mentioned with previous table).

Upvotes: 1

Views: 52

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

Use this array formulas to count the uniques:

=SUM(IF(B1:B8=0.5,1/COUNTIFS(A1:A8,A1:A8,B1:B8,0.5)))

Being an array formula it must be confirmed with Ctrl-Shift-Enter instead of Enter when exiting edit mode. If done correctly then Excel will put {} around the formula.

enter image description here

Upvotes: 1

Related Questions