Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to list minimum 3 values from a row in Excel?
- Thread starter cboz
- Start date
Assuming your numbers in C2:N2, then if you actually want to display them all, select 3 cells eg A1:C1, type in the following formula:-
=SMALL(C2:N2,{1,2,3})
and then array enter it using CTRL+SHIFT+ENTER
Regards
Ken...................
=SMALL(C2:N2,{1,2,3})
and then array enter it using CTRL+SHIFT+ENTER
Regards
Ken...................
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question
- Locked
- Question