Fetch highest number

		Microsoft Office Forums > Microsoft Excel > Excel
Fetch highest number

FAQ

Thread Tools

Display Modes

03-22-2017, 06:41 AM

xor

Windows 10 Fetch highest number

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,103

With your data in A2:E10 and date1 and date2 in G1 and G2 try this array formula:

=MAX(IF((A2:A10>=G1)*(A2:A10<=G2),B2:E10))

Remember to hold down Ctrl and Shift before pressing Enter.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to specify the Outlook_account to fetch an email from?	Officer_Bierschnitt	Excel Programming	2	11-24-2015 04:34 AM
How to fetch data from one sheet to another with complete details and date wise as well	harisjawed86	Excel Programming	1	08-05-2014 09:10 PM
Fetch images from URLs automatically	claftchi	Word VBA	1	12-25-2013 01:25 AM
Highest & lowest Numbers	ibrahimaa	Excel	3	04-23-2012 07:52 PM
Linking sheets to fetch transactions from sheets to another	waqer	Excel	4	09-01-2011 12:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 AM.