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...
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!