is there a way to do this for excel? (somekind of dmax for column3?)

col1       col2         col3

abc         a            abc-a-1

abc         a            abc-a-2

abc         b            abc-b-1

abc         a            abc-a-3

abc         b            abc-b-2

def         a            def-a-1

...

• Moved by Lanlan HuangMicrosoft contingent staff 4 hours 45 minutes ago

In D1:

=A1&"-"&B1&"-"&COUNTIFS(A$1:A1,A1,B$1:B1,B1)

Fill down to the last row with data.

Hi

This is the forum to discuss questions about Excel develop (VBA, Customization). For your question is about formula for Excel, I will move the question to the forum for Excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thank you for your understanding.

Best Regards,

Lan

In D1:

=A1&"-"&B1&"-"&COUNTIFS(A$1:A1,A1,B$1:B1,B1)

Fill down to the last row with

Do you use comma as decimal separator and semi-colon as list separator? If so, change the formula to

=A1&"-"&B1&"-"&COUNTIFS(A$1:A1;A1;B$1:B1;B1)

If you use a non-English version of Excel, you will have to change COUNTIFS to the name of that function in the language of Excel.