Reference a number from a different column in a formula

Posted to microsoft.public.excel.worksheet.functions

rhhince[_2_] rhhince[_2_] is offline

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula for Increasing a Cell Reference by a Given Number	Kentle	Excel Worksheet Functions	3	October 21st 06 03:42 PM
Need to indirectly reference columns 26 using A1 notation based on numeric column number- how to?	KR	Excel Worksheet Functions	5	October 26th 05 07:08 PM
chart label reference based on the column number	z.entropic	Charts and Charting in Excel	2	May 21st 05 05:54 PM
chart label reference based on the column number	bj	Charts and Charting in Excel	0	May 20th 05 07:18 PM
return the column reference number of a function result	Mahendhra	Excel Discussion (Misc queries)	2	May 16th 05 12:46 PM

All times are GMT +1. The time now is 01:14 PM.

Menu

About Us