Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Invoice Number
- 123
- 123
- 1
- 1
- 123
- A
- B
- C
- D
- 123
- Invoice Number
- 123_1
- 123_2
- 1_1
- 1_2
- 123_3
- A
- B
- C
- D
- 123_4
- =IF(COUNTIF($A$1:$A1,A2)>0,A2&"_"&COUNTIF($A$2:$A2,A2),A2)
- Invoice Number
- 123
- 123_2
- 1
- 1_2
- 123_3
- ...
- =IF(COUNTIF($A$2:$A2,A2)>0,A2&"_"&COUNTIF($A$2:$A2,A2),A2)
Add Comment
Please, Sign In to add comment