Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 172
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi, Is there a formula that can list the highest "Priority" based on Due date and Product as priority "1" being the highest?
As an example for Apple - the Earliest due date is 08/10/2020 so this will be Priority 1. Priority 2 would be 23/10/2020.
Thank you
As an example for Apple - the Earliest due date is 08/10/2020 so this will be Priority 1. Priority 2 would be 23/10/2020.
Thank you
Due Date | Product | Quantity | Priority |
30/10/2020 | Apple | 22,000.0 | |
20/10/2020 | Orange | 4,800.0 | |
15/10/2020 | Orange | 7,155.0 | |
2/10/2020 | Pear | 3,800.0 | |
8/10/2020 | Apple | 800.0 | |
22/10/2020 | Orange | 1,750.0 | |
26/10/2020 | Pear | 66,250.0 | |
23/10/2020 | Apple | 1,060.0 | |
12/10/2020 | Orange | 5,500.0 | |
28/10/2020 | Apple | 3,500.0 | |
27/10/2020 | Pear | 16,000.0 | |
21/11/2020 | Banana | 13,000.0 | |
11/11/2020 | Banana | 10,873.0 |