Macro to Remove Unique Rows.

Hi.

I have a spreadsheet that contains sales records (that are imported on a query from a database). The sale ID is in column A and should appear twice or more. There are some rows that only contain one sale ID, and these need to be removed. I've set a conditional format to highlight these, however rather then spend time deleting all these unnecessary rows, is there a macro that can identify a cell whose value only appears once in a range, and delete that entire row accordingly?

Thanks.

A macro could be written.

For a definitive answer, please post a sample workbook.

Regards

Hi,

Use a helper column and in it enter an IF formula with the same logic that you use for the cond. formats. Have the formula return the value "Delete" for the single IDs.

Now filter the range on the word Delete and then select and delete all those rows.

You can create a macro to do this as follows. Create a dynamic range name for your data including the new helper column which we'll assume is column 10 in the named range. Then add the following macro.

Please Login or Register  to view this content.