one way:
<b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">B2</th><td style="text-align:left">=IF(<font color="Blue">ISNA(<font color="Red">MATCH(<font color="Green">A2,A$1:A1,0</font>)</font>),MAX(<font color="Red">B$1:B1</font>)+1,VLOOKUP(<font color="Red">A2,A$1:B1,2,0</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
Excel 2013/2016 |
---|
|
---|
| A | B |
---|
1 | Name | ID |
---|
2 | Mark | 1 |
---|
3 | Mark | 1 |
---|
4 | Rich | 2 |
---|
5 | John | 3 |
---|
6 | Rich | 2 |
---|
7 | John | 3 |
---|
|
---|