Wonga Denga
New Member
- Joined
- Apr 17, 2020
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
I would like to extract the 2nd, 3rd, 4th etc values of a sheet using the LARGE FUNCTION from different columns.
So I want excel to examine columns (H4-H57) + (M4-M47) + (R4-R47) + (W4-W47) and give me the highest value. In another cell I would like the 2nd highest value. In the next I would like the 3rd highest. I tried using the LARGE FUNCTION but it I came with an error. Does anyone know how to approach this using the LARGE FUNCTION? Thanks.
So I want excel to examine columns (H4-H57) + (M4-M47) + (R4-R47) + (W4-W47) and give me the highest value. In another cell I would like the 2nd highest value. In the next I would like the 3rd highest. I tried using the LARGE FUNCTION but it I came with an error. Does anyone know how to approach this using the LARGE FUNCTION? Thanks.