I have a very large spreadsheet and I'm trying to cleanup.
Let me give you a brief description of the spreadsheet.
I have 3 columns of importance
Column 1 = Item #
Column 2 = Date
Column 3 = Location
What I'm looking to do is erase any data where there are less then 2 occurances of the same item # for each location.
1st option = I subtotalled based on date/item/location however I'm not sure how to sort based on the subtotal. If there is a way to do this that would resolve my issue.
2nd option = Would it be possible to create a macro to say if there are less then 2 occurances of the same item # for a given location delete the row.
I would do this manually however we're talking about 50,000 lines of data.
Thank You
DZDNCFSD
Let me give you a brief description of the spreadsheet.
I have 3 columns of importance
Column 1 = Item #
Column 2 = Date
Column 3 = Location
What I'm looking to do is erase any data where there are less then 2 occurances of the same item # for each location.
1st option = I subtotalled based on date/item/location however I'm not sure how to sort based on the subtotal. If there is a way to do this that would resolve my issue.
2nd option = Would it be possible to create a macro to say if there are less then 2 occurances of the same item # for a given location delete the row.
I would do this manually however we're talking about 50,000 lines of data.
Thank You
DZDNCFSD