0

I got Sheet 1. It contains two lists, listA and ListB. I would like to split two lists, like sheet 2 and sheet 3 by using only formula. Because I have a lot of sheets like sheet 1, and I have to split these list many times. List A and B contain same data (ex. 1001 Apple). and I don't want to insert any flag.

How should I do?

enter image description here

I tried to find similar questions, but I couldn't.

Improve this question
New contributor
Tsukasa Watanabe is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

1 Answer 1

Reset to default
0

You need to put formula for each sheet. Give a try to the following formula-

=FILTER(Sheet1!B2:C16,SCAN("",Sheet1!B2:B16,LAMBDA(a,x,IF(ISNUMBER(x),a,x)))="ListA")

enter image description here

Improve this answer
2
  • Hi Harun24hr, Thank you for your quick answer!! I'll try it. I appreciate it!!
    – Tsukasa Watanabe
    Commented 21 mins ago
  • Could you tell me the meaning of this formula more detail? Thank you for your help in advance!
    – Tsukasa Watanabe
    Commented 4 mins ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.