Matrix and cell next to the left

Nelson78

Well-known Member
Joined
Sep 11, 2017
Messages
526
Office Version
  1. 2007
Hello everybody.

In a cell I have a matrix correctly set up that copies a value of another cell.

Suppose, for simplicity:

{=MAX(B5:B10)}

But in effect I need the value in the cell next to left: so, if the max value is B7, i need the value in A7.

How can I instruct the formula?

Thank's.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Code:
=MOD(MAX(B5:B10*10^8+A5:A10),10^8)
Code:
=MAX((B5:B10=MAX(B5:B10))*A5:A10)

ctrl shift enter for the 2 array formulas.
 
Upvote 0
They both don't work.

I'm going to change something (also if it seems to me having translated well the expression in my home language).
 
Last edited:
Upvote 0
Code:
=MOD(MAX(B5:B10*10^8+A5:A10),10^8)
Code:
=MAX((B5:B10=MAX(B5:B10))*A5:A10)

ctrl shift enter for the 2 array formulas.

Are you sure that the function MOD accepts formulas as first parameter?
 
Last edited:
Upvote 0
Ctrl+Shift+Enter run the formula, not just press enter to finish and you will get the answer.
 
Upvote 0

Forum statistics

Threads
1,214,867
Messages
6,122,002
Members
449,059
Latest member
mtsheetz

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
Back
Top