Need Help With Function
I have a list in column A (A1:A10) of various numbers, and a list in column B
(B1:B10). I need a function that outputs the number in column B that is in the same row as the smallest number in column A. I don't want to sort the list. Also I would also like to know how to output the cell reference of the smallest number in the list. Example: A1:A10 - 24, 35, 12, 42, 18, 29, 30, 98, 76, 23 B1:B10 - 45, 67, 21, 78, 34, 67, 25, 86, 35, 98 C1 - 21 D1 - A3 |
Your First Question: =INDEX(B1:B10,MATCH(MIN(A1:A10),A1:A10,0))
Your Second Question: ="A"&MATCH(MIN(A1:A10),A1:A10,0) -- Regards, Dave "Sloth" wrote: I have a list in column A (A1:A10) of various numbers, and a list in column B (B1:B10). I need a function that outputs the number in column B that is in the same row as the smallest number in column A. I don't want to sort the list. Also I would also like to know how to output the cell reference of the smallest number in the list. Example: A1:A10 - 24, 35, 12, 42, 18, 29, 30, 98, 76, 23 B1:B10 - 45, 67, 21, 78, 34, 67, 25, 86, 35, 98 C1 - 21 D1 - A3 |
Thanks. What if I wanted to find the reference of the smallest cell in an
array? Example: A2:A4 - 25, 13, 64 B2:B4 - 53, 26, 98 C2:C4 - 46, 10, 32 A1 - C3 "David Billigmeier" wrote: Your First Question: =INDEX(B1:B10,MATCH(MIN(A1:A10),A1:A10,0)) Your Second Question: ="A"&MATCH(MIN(A1:A10),A1:A10,0) -- Regards, Dave "Sloth" wrote: I have a list in column A (A1:A10) of various numbers, and a list in column B (B1:B10). I need a function that outputs the number in column B that is in the same row as the smallest number in column A. I don't want to sort the list. Also I would also like to know how to output the cell reference of the smallest number in the list. Example: A1:A10 - 24, 35, 12, 42, 18, 29, 30, 98, 76, 23 B1:B10 - 45, 67, 21, 78, 34, 67, 25, 86, 35, 98 C1 - 21 D1 - A3 |
All times are GMT +1. The time now is 02:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com