Incremental forumla needed

G

Gaffnr

Hi
I have a list of values that im using in a vlookup up. However, where in
rows they repeat, iwant to inrecment the value by 1 . e.g

Column A has
ABC
DEF
DEF
DEF
HIJ
HIJ
JKL
MNO

I want to turn this into, using a formula :
ABC
DEF
DEF1
DEF2
HIJ1
HIJ2
JKL
MNO

Thanks
Rob
 
G

Greg Wilson

Assumed is that the data starts in cell A1 and that your example had a typo
where the output example should have had HIJ/HIJ1 instead of HIJ1/HIJ2. Put
this in a different column and dag down:

=A1&IF(COUNTIF(A$1:A1, A1) =1, "", COUNTIF(A$1:A1, A1)-1)

Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding duplicates 2
Multiples conditions in an array 3
Lookup Wizard 4
How do I set up a formula to count only unique items in a column? 3
array search 8
Can we filter / sort by a formula from Reference worksheets ? 1
lookup with IF criteria 2
IF or similar but true result to display in consecutive row 5

Top