View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaffnr Gaffnr is offline
external usenet poster
 
Posts: 65
Default Incremental forumla needed

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
--
Rob Gaffney