Well Hello Ladies and Gentlemen.
I have been lurking around this site for a while and have found the answers to most of my problems, so thanks to you all.
However I now have a hum-dinger of a problem that I can't solve.
Purely for example consider this:
a b c
1 Smith Mon 2 apples
2 Jones Mon 3 apples
3 Smith Tue 2 apples
4 Smith Tue 2 apples
5 Jones Wed 3 apples
6 Jones Wed 5 apples
What I want to do is delete duplicates in this list (row 3&4, delete row 4) but leave non-similar rows alone (row 5&6 where Jones buys more apples on the same day).
Most of the deletion codes I have seen will delete a row based on the data in a single column. However I need to check for repeated data in three columns and only delete when all three columns contain the same data.
The code I have, from http://www.cpearson.com/excel/deleting.htm will delete the row based on a single column value and it's beyond my tiny mind to get it to check the criteria of all three columns.
HELP.....
Bookmarks