I been struggling to do this for sometime now.
I have two sheets.
I have one column in the first sheet which has duplicate entries. I want to keep this as it is.
I want to create a new column in the second sheet, which is a copy of the column in the first sheet, but without the duplicate entries.
I want to do all this using formulas and not macros, because I want the second sheet to update, as and when new entries are made in the first sheet.
Also ideally I want the formula to apply to the entire column i.e for the 1048576 rows.
To further illustrate:
Sheet 1 has column A which has the following entries
Apple
Orange
Apple
Grape
Tomato
Orange
Sheet 2 should have the column A without the duplicates in column A of Sheet 1, which is:
Apple
Orange
Grape
Tomato
Thank you very much in advance, for taking the time to help me out.
Bookmarks