Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

1 Answer 1

Using LibreOffice 3.6.3 (a mild fork of OpenOffice), I was able to get this to work just by changing "J" to "A" in your formula and inputting data in column A such as "John, Joe, John, Joe" -- the second occurrence has a "2" at the end, the third occurrence of each datum has a "3" at the end, and so on.

What error specifically do you get, and which version of OpenOffice are you using?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.