zuriqi
Board Regular
- Joined
- Dec 8, 2008
- Messages
- 79
Hi,
I am looking for a formula to find the 1st, 2nd and 3rd smallest value for the date of the "Date" column which has the same code in "Code" column. Formula to give space if cell in "Date" Column is empty or if code is repeated in column C, D or E. as shown in the table below.
<tbody>
</tbody>
I am looking for a formula to find the 1st, 2nd and 3rd smallest value for the date of the "Date" column which has the same code in "Code" column. Formula to give space if cell in "Date" Column is empty or if code is repeated in column C, D or E. as shown in the table below.
A | B | C | D | E | |||||
1 | Date | Code | 1st Small | 2nd Small | 3rd Small | ||||
2 | 01-Oct-17 | A |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
3 | 01-Oct-17 | A | |||||||
4 |
<tbody> </tbody> | B |
<tbody> </tbody> |
<tbody> </tbody> | |||||
5 |
<tbody> </tbody> | D |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
6 |
<tbody> </tbody> | C |
<tbody> </tbody> | ||||||
7 |
<tbody> </tbody> | A | |||||||
8 | B | ||||||||
9 |
<tbody> </tbody> | D | |||||||
10 |
<tbody> </tbody> | D | |||||||
11 | C | ||||||||
12 |
<tbody> </tbody> | B | |||||||
13 |
<tbody> </tbody> | A |
<tbody>
</tbody>