Index offset I think (Thanks In Advance)

nehpets12

Active Member
Joined
Feb 22, 2002
Messages
453
Book3
ABCDEFG
1DateQtyAnswerLookingFor
2Monday7MondayHowdoIFindHighestQtyThatMatchesMonday7
3Monday2TuesdayHowdoIFindHighestQtyThatMatchesTuesday4
4Monday3
5Monday4
6Monday5
7
8Tuesday1
9Tuesday2
10Tuesday4
11Tuesday3
12
Sheet1
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

s-o-s

Active Member
Joined
Apr 14, 2002
Messages
384
Hi Nehpets12,

This can be done with an array formula. The formula from cell E2 is Entered by Holding Ctrl + Shift and then hitting Enter this will put the braces around the formula and make it give you the correct value.

Book1
ABCDE
1DateQtyHighest
2Monday7Monday7
3Monday2Tuesday4
4Monday3
5Monday4
6Monday5
7
8Tuesday1
9Tuesday2
10Tuesday4
11Tuesday3
Sheet2

:)
 

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,934
Hi nehpets12,

Array enter in G2 the formula:

=MAX(IF($A$2:$A$11=E2,$B$2:$B$11))

and copy down to G3 and so on.

Dont forget it is an ARRAY formula you must press CTRL+SHIFT+ENTER

Eli
 

Forum statistics

Threads
1,144,307
Messages
5,723,629
Members
422,505
Latest member
Noar33

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top