Fetch highest number

[am_gup123]

Hi,

I need help in writing an excel formulae to achieve this –

In Sheet1, there are 4 columns Date,A,B,C,D. These columns contain different numbers while the date field contains date, the data is sorted in ascending order of date.
In Sheet2, I have a date range (say date1 & date2).

What I want is to fetch the highest number among columns A,B,C,D in sheet1 in the specified date range (date 1 & date2).

Example-
Sheet1 :
Date------A-B-C-D
1-Jan-17-1-2-3-5
2-Jan-17-6-4-5-7
3-Jan-17-1-2-5-3
4-Jan-17-3-4-3-6
5-Jan-17-6-4-1-7
6-Jan-17-2-7-9-4
7-Jan-17-6-1-2-4
8-Jan-17-3-6-9-3
9-Jan-17-1-3-2-1

Sheet2:
Date1=3-jan17 ; date2=7-jan-17
Highest number between this date range is 9…..so 9 should be displayed.

Thanks.

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/997122-fetch-highest-number.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

You had already posted it in the correct forum the first time.