Index-Match Array Formula

[encioman]

Hello,

Can you help me with this, I need to put in the result the max "320"
https://docs.google.com/spreadsheets...it?usp=sharing

 

[Tom.Jones]

hi,

=max(a1:e1)


ps is this a homework?

 

[Peter_SSs]

Is this a Google Sheets question asked in an Excel forum?

 

[encioman]

Thank you Tom, but you may notice that I need to use other condition as the formula i've used

 

[encioman]

Hi Peter,

Sorry if it's not appropriate to use google sheet in sharing an excel sheet. I just don't know how to share the actual excel sheet to explain further my query ...

my apologies indeed... God bless

 

[Peter_SSs]

Hi Peter,

Sorry if it's not appropriate to use google sheet in sharing an excel sheet. I just don't know how to share the actual excel sheet to explain further my query ...

my apologies indeed... God bless

It just needs to be clear whether you were looking for an answer in Excel or an answer in Google Sheets. No problem providing an example that way but some potential helpers may just bypass because it was not in Excel.

 

[encioman]

It just needs to be clear whether you were looking for an answer in Excel or an answer in Google Sheets. No problem providing an example that way but some potential helpers may just bypass because it was not in Excel.

Thank you Peter... well noted. Yeah I noticed some differences with the actual excel and google sheets... definitely I want to apply it in excel ... but i hope you can develop or they(google) can develop to make it equal to excel like the application in "one drive".. I am amazed with simultaneous editing in one file in google sheets. "One drive" also has but it's not easy as google sheets...

How about my query, do you have some suggestion?

 

[Peter_SSs]

How about my query, do you have some suggestion?

I don't understand what you are wanting. In what way does the post 2 suggestion not meet your needs?

 

[Sam_D_Ben]

@encioman

[COLOR=blue]Why is that formula in "G1" to get the Max, its connected to other rows. Please check[/color]

 

[encioman]

@encioman

[COLOR=blue]Why is that formula in "G1" to get the Max, its connected to other rows. Please check[/COLOR]

Thanks Muzama,

it's just i need the max in row #1 in which must have the max value in row #3 & 4....