Hello, I would really appreciate if you could help with the following.
As seen the attachment I have three columns named Row Number, Person Name & Fruit.
I want to filter out the data whereby people with different names eat the same fruit.
So, I have two sheets in the excel file- the "Input" sheet which presents the raw data, and "output" sheet which is what I want to get.
So, I want to be able easily filter out the data based on the logic above. So in my case, output will only be the below, as these are the only raws which satisfy the condition i.e. people with different names eat the same fruit.
3 George Orange
5 Smith Orange
Is there a way I can filter this out automatically in excel? Thank you very much.
Bookmarks