The formula [here] seems to fit what I’m looking for however I’m extremely new at this and don’t know how to apply it to my situation.
What I want to accomplish is; upon entering new data to sheet1 columnA, auto update sheet2 columnA (consisting of preexisting data of 167 rows) while excluding duplicate data from sheet1 on sheet2.
Can any one help me with this?
Bookmarks