Share via

I need formula gives me simbole as h1 if a specific cell has writing and the next cell is h2

Anonymous
2024-01-30T13:02:48+00:00

What I have. What I need

A. B. C. E. F. H. I. J. K.

1 w M v. A1 A2 B1

2 g. H. A1 B1

  1. K. F. J D. A1. A2 A3. B1

4 s q. Y. L. A1 A2. B1. B2

What I need if any cell in column A or B or C have writing any thing gives me letter A by count adding to it if first cell gives serial 1 to be A1 by formula in column H put letter A adding to number 1 for the first cell in column A to be A1 and so on for column B to be if has writing to gives by formula A also but the count add is next serial 2 to be A2 in column I and so on but if we go to cell E1 formula gives me B1 and if F1 is empty put blank but if like F4 has writing put B2

Thanks

Microsoft 365 and Office | Excel | For business | 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

Answer accepted by question author

Anonymous
2024-01-31T03:30:33+00:00

Based on the data in H to L， use another formula to get the final result.

=IFERROR(INDEX($H1:$L1,SMALL(IF($H1:$L1="","",COLUMN($A$1:$E$1)),COLUMN(A1))),"")

Was this answer helpful?

1 person found this answer helpful.
0 comments

11 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-30T15:05:57+00:00

    Hi Snow

    I am not familiar with macro

    My excel is excel 10

    I appreciate your trying for another formula

    I hope you will

    Thanks a lot

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-01-30T14:55:18+00:00

    Could you share us your office version? I am trying other formula.

    Image

    Do you accept macro? Macro can do it.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-01-30T14:45:47+00:00

    Hi Snow

    Thanks for your effort.

    But my excel not found in it these formulas. Hstack. and. Sequence

    Is there any formula which found in old excel.

    Thanks

    Emad

    Was this answer helpful?

    0 comments
  4. Anonymous
    2024-01-30T13:10:24+00:00

    formula in H1 and fill down.

    =HSTACK("A"&SEQUENCE(1,COUNTA(A1:C1)),"B"&SEQUENCE(1,COUNTA(D1:E1)))

    Was this answer helpful?

    0 comments