exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi Team,
I have below data, looking for a formula in column F to see which is the lowest number in column E for column A. Expected result provided in column F.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have below data, looking for a formula in column F to see which is the lowest number in column E for column A. Expected result provided in column F.
Column A | Column B | Column C | Column D | Column E | Column F |
Number | name | date | todays date | today date - date | Result |
17137 | BD | 04/07/2019 | 30/07/2019 | 26 | TRUE |
17137 | BR | 17/05/2019 | 30/07/2019 | 74 | |
17137 | EP | 04/07/2019 | 30/07/2019 | 26 | TRUE |
17137 | LD | 04/07/2019 | 30/07/2019 | 26 | TRUE |
17137 | PA | 14/06/2019 | 30/07/2019 | 46 | |
17137 | TS | 20/05/2019 | 30/07/2019 | 71 | |
18370 | BB | 20/05/2019 | 30/07/2019 | 71 | |
18370 | BR | 20/05/2019 | 30/07/2019 | 71 | |
18370 | EP | 20/05/2019 | 30/07/2019 | 71 | |
18370 | LD | 20/05/2019 | 30/07/2019 | 71 | |
18370 | PA | 19/06/2019 | 30/07/2019 | 41 | |
18370 | TS | 29/05/2019 | 30/07/2019 | 62 | TRUE |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>