Thread
:
Reference a number from a different column in a formula
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
rhhince[_2_]
external usenet poster
Posts: 48
Reference a number from a different column in a formula
I have 2 sets of numbers in 2 columns A and B example:
1 5
2 8
3 36
4 52
5 10
=MAX(B1:B5)
How do I get 3 from column A as my answer from using MAX(B1:B5)? Do I
need index, offset, match?
Reply With Quote
rhhince[_2_]
View Public Profile
Find all posts by rhhince[_2_]