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 Friday, May 22, 2015 3:01 AM
dmax?
May 21st, 2015 6:10am
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.
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2015 3:38am
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
May 22nd, 2015 4:27am
This topic is archived. No further replies will be accepted.
Other recent topics
