Nanogirl21
Active Member
- Joined
- Nov 19, 2013
- Messages
- 330
- Office Version
- 365
- Platform
- Windows
Hi,
I am looking for a formula that will be able to populate a cell with the max value in a range based on a custom list.
Example.
CUSTOM LIST (Smallest to Largest) = ORANGE 00, APPLE 05, BANANA / HOLD, PINEAPPLE
(If I have to have the list somewhere in my workbook it will be on a sheet called Holidays in Cell E2-E15 sorted from smallest to largest. All other info is on Sheet 1)
The range is W:Z and I am looking for the max value to populate in AA
<tbody>
</tbody>
Thank you for the help.
I am looking for a formula that will be able to populate a cell with the max value in a range based on a custom list.
Example.
CUSTOM LIST (Smallest to Largest) = ORANGE 00, APPLE 05, BANANA / HOLD, PINEAPPLE
(If I have to have the list somewhere in my workbook it will be on a sheet called Holidays in Cell E2-E15 sorted from smallest to largest. All other info is on Sheet 1)
The range is W:Z and I am looking for the max value to populate in AA
W | X | Y | Z | AA |
BANANA / HOLD | PINEAPPLE | ORANGE 00 | APPLE 05 | PINEAPPLE |
APPLE 05 | ORANGE 00 | BANANA / HOLD | BANANA / HOLD | BANANA / HOLD |
<tbody>
</tbody>
Thank you for the help.