Share via

MS Excel Creating a helper list.

Anonymous
2022-03-08T11:52:44+00:00

Hello,

I currently have the below list in Column X.

I want to to create a list in Column Y as shown based on list X.

What code can do this? I want to input a code in Column Y that can do this. Helper columns are fine.

Thanks in Advance

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 101.8K Reputation points Volunteer Moderator
    2022-03-08T23:38:18+00:00

    Hi,

    In cell Y3, enter this formula and copy down

    =IF(ISNUMBER(X3),LOOKUP(2,1/ISTEXT(X$2:X3),X$2:X3)&X3,"")

    Hope this helps.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2022-03-08T13:12:11+00:00

    It's always a pleasure to help in any way, I'll close the topic here, so that your case can help other people with the same question.

    If you can, I would be grateful if you can rate my answer.,

    Good work for you.

    André

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2022-03-08T13:31:37+00:00

    Hi,

    *I know Our Knowledgeable Contributor @*Minhokiller has already answered Your question.

    But, I solved this question out of curiosity :-)

    Formula in cell B4 is: =IF(NOT(ISNUMBER(A4)),"",INDEX($A$3:$A$24,MAX(($A$3:A4=1)*(ROW($A$3:A4)-2))-1)&A4)

    Advantage: if the alphabet series comprises 2 letters (e.g. AA, AB, etc.), My formula will yield correct result.

    Image

    Please respond if You require further assistance. I will try My best to be of help.

    If I was able to help You, please mark My response as answer and helpful.

    Thank You!

    0 comments
  4. Anonymous
    2022-03-08T13:02:43+00:00

    Thank you so much.

    Yes it works

    0 comments
  5. Anonymous
    2022-03-08T12:48:26+00:00

    Hi

    My name is André. I am an independent consultant.

    See if this works for you,

    I created a conditional formula in the second Column (Y), with the following formula in C6 and dragged it down:

    =IF(ISNUMBER(B6);IF(C5="";B5&B6;LEFT(C5;1)&B6);"")

    (In my case the separator is a dot and a comma)

    Answer here so I can continue helping you.

    André.

    0 comments