Home

Multiple minimum numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-776581%22%20slang%3D%22en-US%22%3EMultiple%20minimum%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776581%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20look%20up%20the%20two%20small%20numbers%20in%20a%20range%20and%20post%20them%20in%20adjacent%20cells%3F%3C%2FP%3E%3CP%3EFor%20example%2C%20here%20are%20two%20ranges%20with%20whole%20numbers%3A%3C%2FP%3E%3CP%3ERange%20A%20Range%20B%3C%2FP%3E%3CP%3E3%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204%3CBR%20%2F%3E2%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%204%3CBR%20%2F%3E1%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%203%3CBR%20%2F%3E1%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%202%3C%2FP%3E%3CP%3EExpected%20Outcome%3A%3C%2FP%3E%3CP%3E1%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%202%3CBR%20%2F%3E1%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%203%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-776581%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776608%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20minimum%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776608%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383377%22%20target%3D%22_blank%22%3E%40selecting_low_nmbers175%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsmall-function-17da8222-7c82-42b2-961b-14c45384df07%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3EUse%20the%20SMALL()%20function.%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
selecting_low_nmbers175
Occasional Visitor

How can I look up the two small numbers in a range and post them in adjacent cells?

For example, here are two ranges with whole numbers:

Range A Range B

3             4
2            4
1            3
1           2

Expected Outcome:

1          2
1          3

 

1 Reply
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies