Im trying to find a formula to return the value of the orginal MAX value.

**ossy009** · 02-21-2019, 03:32 PM

I have a formula =INDEX($C$2:$N$2,0,MATCH(MAX($C12:$N12),$C12:$N12,0)) that returns the month of the highest fuel used which is october,the trouble is im trying to get excel to return the orginal value of the Max function from the cell total fuel which is 1157 aswell as october the month both values appearing iamge 1.png iamge 1.png iamge 1.png iamge 1.png

**Fluff13** · 02-21-2019, 03:42 PM

If you simply want the value, rather than the month just use

Please Login or Register  to view this content.

**Roel Jongman** · 02-21-2019, 03:50 PM

Try

Formula:

Please Login or Register  to view this content.

edit: or the more obvious choice by Fluf13

Im trying to find a formula to return the value of the orginal MAX value.

LinkBack

Thread Tools

Rate This Thread

Display

Im trying to find a formula to return the value of the orginal MAX value.

Re: Im trying to find a formula to return the value of the orginal MAX value.

Re: Im trying to find a formula to return the value of the orginal MAX value.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to find a value in col B and return value in col A

[SOLVED] Formula to find value in col A and return value in col B

[SOLVED] Find date between 2 dates and place corresponding values of orginal date if between 2 date

[SOLVED] Formula to find data and return Yes or No

Find and return the last used cell in a row, Formula or VBA?

Formula to find a name and return a date from the same row.

[SOLVED] find formula and return value

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions