Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If I have two rows of numbers...
5 10 15 20 25 30 35 40 45 50 1 16 23 18 64 28 46 72 18 26 Is there a formula I can insert, in another cell elsewhere on the sheet, that will find the largest value in the second row, but return the corresponding number from the first row? In the above example, I could use "=max(b1:b10)" to find the largest number in row b, but how do I reference row a? Thanx. |