i have data saved in Dump sheet of attached excel file. i want only those rows to be visible/filtered whose value for "Agent ID" colum mathces the values that i have stored in IDM sheet. please help me to get this done. i have tried using advance filter but unable to do that. you can download...