excel / open office - append an incrementing value to all non-unique fields
- by mheavers
I have a large table of about 7500 store names. I need to search through those names and, if they are not unique, append an incrementing value, for example:
store_1
store_2
etc.
Anyone know how to do this?
For another project, I was using this:
=J1&IF(COUNTIF($J$1:J1,J1)1,COUNTIF($J$1:J1,J1),"")
but in open office this gives an error, and in google spreadsheets, it times out because my database is so big. Any suggestions?