Reference a number from a different column in a formula

R

rhhince

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Match and delete rows on two different sheets from reference numbers 4
Setting column width in a table with a macro is not working 0
SORT data containing formula 5
Finding the right style field in VBA 0
HELP: IF Statement between Dates for Reverse Index failing 0
Row reference for consecutive series calculation 0
List all tables, including document structure 0

Top