Hi all,

I want working to consolidate certain information on my master list to a single row. for example. my master list contains contact information that is enter over and over again throughout the year for different information listed by dates.

i am making a new sheet that will auto populate just the contact information, but only ONCE. Vlookup will locate my contact over and over again and so will =sheet!1A2 making it s massive repeative list i don't want in sheet two. Is there a formula or if statement that will look for certain data source on master list (sheet 1) and if its already listed, it will not include in on sheet two?

thanks for your help