Forum Discussion
Filter Help
Hello,
What I am trying to do seems like it should be simple but I am having a hard time. All I need is for columns 1 and 2 to show me the contents of A and C respectively anytime column B matches anything in column N.
So from this:
| A | B | C | N | 1 | 2 |
| x | 1 | b | 1 | ||
| y | 2 | a | 3 | ||
| y | 1 | a | |||
| y | 3 | b | |||
| x | 2 | b | |||
| x | 1 | a | |||
| x | 3 | a |
to:
| A | B | C | N | 1 | 2 |
| x | 1 | b | 1 | x | b |
| y | 2 | a | 3 | y | a |
| y | 1 | a | y | b | |
| y | 3 | b | x | a | |
| x | 2 | b | x | a | |
| x | 1 | a | |||
| x | 3 | a |
I was able to do this for a single line that matched the first row in N but that was as far as I could get.
I tried mixing XLOOKUP with FILTER but that wouldn't account for multiple values in N. I tried using CHOOSEROW and XMATCH but I couldn't seem to get non-adjacent columns to come back.
My example is simplifying; I actually have 25 columns and need 11 of them to show anytime the 13th of them has the same value another, specific cell. There are nearly 5000 rows and I need approximately 400 of them to populate.
Please help?
alielle3 The attached file contains a rather straightforward solution for your simplified example. See if you can adapt to your real data.
