Hi all,
I would like to ask your help with a VBA code, as I am still a bit new on this field. I attached an excel sheet, on Sheet 1 the table I would like to reduce, and how, on sheet 2 the outcome I would like to achieve but I have done this manually,and it is practically impossible on my real data set, so I started to write a vba code to format it.
On the example, there are First Names, Last Names, Fruits and Basket sizes. So if First Names and Last Names and the Fruits match in several rows, I would like to delete the dupli-tripli-cate rows - and keep only 1, and the 1 that is kept, should be the one that has 05 basket in the basket size column, if there is no 05 basket then it doesn't matter which one is kept.
If in several (unknown amount) rows, in column A B and C the values are the same, then delete these rows until only 1 is left, if in D the value is "05*" then keep that, as the 1 row that is left.
I was thinking maybe do it with loops, but I am really not sure, and don't exactly know how. Anyone could help please?
Thank you!
Bookmarks