|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com