LinkBack URL
About LinkBacks
Dear Forum Users,
I would like to kindly ask for help regarding creating a formula that would set the numbers in A2:D2 in ascending order in F2:I2, as shown in the file a created as well as in the screenshot.
Thank you in advance
Dear Forum Users,
I would like to kindly ask for help regarding creating a formula that would set the numbers in A2:D2 in ascending order in F2:I2, as shown in the file a created as well as in the screenshot.
Thank you in advance
In F2, copied across and down:
=SMALL($A2:$D2,COLUMNS($F2:F2))
You may need to use ; instead of ,
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
One way in F2 copied across and down
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks