Sorry Have Posted This Before But Hopefully Made It Easier

[nehpets12]

I am trying to put in column F the W/O number I have sorted column E into date order and there are duplicate dates how do I lookup the date and put in the W/O when there are 2 or more duplicates

Book2
	A	B	C	D	E	F	G
1	Date	W/O	Customer
2	23/Oct	4273	Cleanaway		18/Oct
3	21/Oct	4257	Ddd		21/Oct
4	18/Oct	4270	Cleanaway		23/Oct
5	30/Oct	4268	Cleanaway		23/Oct
6	23/Oct	4307	Gulliver'S		30/Oct
7	27/Sep				01/Nov
8	27/Sep				04/Nov
9	27/Sep				13/Nov
10	27/Sep				15/Nov
11	15/Oct				15/Nov
12	04/Nov	4305	Ddd
13	15/Nov	4278	RmcPlantHire
14	01/Nov	4311	HendyLennoxLtd
15	13/Nov	4274	Cleanaway
16	15/Nov	4211	Ddd
17	30/Sep
18
19							.
Sheet2

 

[Andrew Poulsom]

See the example below. Note that column F contains array formulas - press Ctrl+Shift+Enter not just Enter.

FindMultipleOccurrences.xls
	A	B	C	D	E	F
1	W/O	Customer
2	23-Oct	4273	Cleanaway	1	18-Oct	4270
3	21-Oct	4257	Ddd	1	21-Oct	4257
4	18-Oct	4270	Cleanaway	1	23-Oct	4273
5	30-Oct	4268	Cleanaway	1	23-Oct	4307
6	23-Oct	4307	Gulliver'S	2	30-Oct	4268
7	27-Sep			1	1-Nov	4311
8	27-Sep			2	4-Nov	4305
9	27-Sep			3	13-Nov	4274
10	27-Sep			4	15-Nov	4278
11	15-Oct			1	15-Nov	4211
12	4-Nov	4305	Ddd	1
13	15-Nov	4278	RmcPlantHire	1
14	1-Nov	4311	HendyLennoxLtd	1
15	13-Nov	4274	Cleanaway	1
16	15-Nov	4211	Ddd	2
17	30-Sep			1
Sheet1