Forum Discussion
Solved
Formula Duplicate values given a unique number
Good Afternoon,
Im after some help with a formula to automatically add a .01 to any duplicate PO found in my list
The list below has PO some are the same, i need these but would like to auto add on to them,
example: P209757, the second duplicate would be P209757.01, then .02 etc etc.
Is this possible?
Many thanks hope this made sense.
| PO |
| P209776 |
| P209757 |
| P209757 |
| P209757 |
| P209759 |
| P209761 |
| P209762 |
| P209749 |
| P209752 |
| P209752 |
marc47555 A quick-and-dirty solution. Try this one, supposing your list of PO's (including a header) starts in A1 and copy it down.
=IF(COUNTIF($A$1:A2,A2)=1,A2,A2&".0"&COUNTIF($A$1:A2,A2)-1)
3 Replies
marc47555 A quick-and-dirty solution. Try this one, supposing your list of PO's (including a header) starts in A1 and copy it down.
=IF(COUNTIF($A$1:A2,A2)=1,A2,A2&".0"&COUNTIF($A$1:A2,A2)-1)Riny_van_Eekelen Excellent.. works super thank you very much
marc47555 Most welcome!
