Hello everyone,

First of all, I am very new to the forum and quiet a quite inexperienced Excel user, so my apologies beforehand if I frame my question wrong because of misunderstandings etc.

So, this is my situation:

I have a list of panel data which is too large to handle by hand: this data is in three columns (column headers: year, id, rank). I have a column which contains all the id values I need the information for.

I tried to use the 'Advanced filter' tool to filter by id. However, when I look at my filtered data, rows appear as well in which I find id that were not in my set of selected data.

Anyone knows a solutions to my problem?

Thank you in advance.

Best regards,
Ralph