Countif Function

[chief_abound]

Snap10.jpg

What formula should I use to get the C column value?

[Phuocam]

Try:

=A1&"-"&ROUND(SUM(IF($A$1:A1=A1,1/COUNTIFS($A$1:A1,A1,$B$1:B1,$B$1:B1),0)),0)

Ctrl+Shift+Enter.

[leelnich]

Hi all- If your data is sorted as shown (primary = col A, secondary = col B), then you can use this.
In C1:

Please Login or Register  to view this content.

In C2 and copied down:

Please Login or Register  to view this content.

[chief_abound]

Hi! Phuocam

Thank you so much!

[chief_abound]

Hi! leelnich

Thank you for answer.