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 |