I am definitely a beginner when it comes to advanced Excel syntax. I tried searching for an answer to my question, but I may be too inexperienced to know how to look. Also possible I misspecified my title. Apologies if this has been answered previously.
Say I have the following 3 columns
A B C
1 Alabama Alabama Red
2 Alaska Wyoming Blue
3 Arizona Alaska Yellow
4 Arkansas Florida Green
5 California Arkansas Black
And I want to produce a list of same-row B/C pairs that have B values equal to A values:
D E
1 Alabama Red
2 Alaska Yellow
3 Arkansas Black
How can I do this?
Thank you thank you thank!
Aucun commentaire:
Enregistrer un commentaire