Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching columns and removing duplicates
Apologies - i've tried finding the answer to this in an already posted
question, but i'm struggling. I have a code in column A and a date in column G. There are different combinations of both, plus some codes without dates (blanks), but also duplicates. I want to copy these to a different sheet but with only one combination of each code and date, not including the blanks. Any ideas?? Much appreciated. This bit isn't urgent but would be a nice touch! Once here, I then want to have the top ten (newest date) of each code and date to go elsewhere. I think this might be using =LARGE? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Sorting 2 columns according to matching cells, and fishing for duplicates | Excel Discussion (Misc queries) | |||
matching values in columns that contain duplicates | Excel Discussion (Misc queries) | |||
Removing Duplicates | Excel Worksheet Functions | |||
removing duplicates | Excel Discussion (Misc queries) | |||
Removing Duplicates | Excel Discussion (Misc queries) |