| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Incremental forumla needed
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 "Gaffnr" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Incremental forumla needed
thanks Greg - Genius. you just saved me hours of work
rob -- Rob Gaffney "Greg Wilson" wrote: 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 "Gaffnr" wrote: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Incremental forumla needed
Happy to help. Thanks for the feedback.
Greg "Gaffnr" wrote: thanks Greg - Genius. you just saved me hours of work rob -- Rob Gaffney "Greg Wilson" wrote: 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 "Gaffnr" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Incremental Numbering | Excel Worksheet Functions | |||
| Forumla help needed | Excel Discussion (Misc queries) | |||
| Incremental numbering | Excel Discussion (Misc queries) | |||
| Incremental comparison | Excel Worksheet Functions | |||
| help with forumla needed... getting a yes/no answer to ?? | Excel Worksheet Functions | |||
Linear Mode
