excel_user_1966
New Member
- Joined
- Mar 24, 2002
- Messages
- 7
I need to search my worksheet called Dates, and in the range of F6 to F100 find certain entries (but only look at the cells with data). The entries to copy onto my sheet Duplicates that I'm searching for will be kind of unique entries.. i.e.
If my lst is...
18th June
19th June
7th May
19th June
20th May
7th May
I wish that onto my sheet Duplicates the list will read:
18th June
7th May
19th June
20th May
there are only four different entries - because 7th May and 19th June are in it twice. So ignore a data if it already appears.
To the right of the list, there needs to be a number of how many times the date appears... i.e. now my list will show:
18th June | 1
7th May | 2
19th June | 2
20th May | 1
Can anyone guide me on how to do this?
If my lst is...
18th June
19th June
7th May
19th June
20th May
7th May
I wish that onto my sheet Duplicates the list will read:
18th June
7th May
19th June
20th May
there are only four different entries - because 7th May and 19th June are in it twice. So ignore a data if it already appears.
To the right of the list, there needs to be a number of how many times the date appears... i.e. now my list will show:
18th June | 1
7th May | 2
19th June | 2
20th May | 1
Can anyone guide me on how to do this?