Hello,
I can't seem to get a Large formula to work based on two criteria's.
I can easily get a oldest value based one value, but I'm struggling to add another. See table below;
The 227 figure is based on =LARGE(IF(B:B="Jim",D:D),1) - so it returns the oldest days old for Jim.
However, when I want to the reference number as another search criteria, I get the #NUM error and have no idea why. Formula is as follows - =LARGE(IF(B:B="Jim",IF(C:C="2020",D:D)),1).
Basically, I want to create a top 5 but have no idea why that formula does not work. Any help would be greatly appreciated.
I can't seem to get a Large formula to work based on two criteria's.
I can easily get a oldest value based one value, but I'm struggling to add another. See table below;
The 227 figure is based on =LARGE(IF(B:B="Jim",D:D),1) - so it returns the oldest days old for Jim.
However, when I want to the reference number as another search criteria, I get the #NUM error and have no idea why. Formula is as follows - =LARGE(IF(B:B="Jim",IF(C:C="2020",D:D)),1).
Basically, I want to create a top 5 but have no idea why that formula does not work. Any help would be greatly appreciated.
Name | Reference | Days old | 227 | Jim Days Oldest | ||
Jim | 2020 | 114 | #NUM! | Jim and 2020 Days Oldest | ||
Jim | 2021 | 120 | ||||
Jim | 2021 | 227 | ||||
Sam | 2021 | 51 | ||||
Sam | 2020 | 47 | ||||
Jim | 2020 | 77 | ||||
Steve | 2021 | 290 | ||||
Steve | 2022 | 198 | ||||
Harry | 2020 | 84 | ||||
Jim | 2021 | 79 | ||||
Steve | 2020 | 77 | ||||
Harry | 2022 | 57 | ||||
Sam | 2021 | 54 | ||||
Sam | 2020 | 41 | ||||
Steve | 2020 | 41 | ||||
Jim | 2021 | 40 | ||||
Jim | 2020 | 32 | ||||
Harry | 2022 | 23 | ||||
Steve | 2021 | 73 |