Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


Anyone know how to do this?

For another project, I was using this:


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

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


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.