Duplicate Values

ajuelsgaard

I have a sheet that because of some date columns we have to have, has many lines that are duplicates. Is there a way to filter out duplicate lines based on an alpha numberic column name (Offer Name)? I would prefer to not overcomplicate it with helper columns and such if I can get away with it.

Duplicates.png

Paul Newcome

How are you currently bringing them in?

ajuelsgaard

Lines are either being entered directly into the sheet or through a form and then copied over to other sheets through automation.

Paul Newcome

All of the cells in your screenshot are column formulas with cross sheet references. Are you using some type of INDEX formula?

ajuelsgaard

Nope. When they move from sheet to sheet, they are either copied or moved so there are no INDEX or MATCH formulas.

Paul Newcome

So is your screenshot the rows that you are wanting to copy over to the other sheet then?