Find MAX value in data containing '#N/A'

Steve_B · #1 10-29-2013, 07:49 AM

Thank you, Pecoflyer. Your solution is exactly what I needed. You are indeed an expert.

Kevin@Radstock · #2 10-30-2013, 12:02 AM

Quote:

Originally Posted by Steve_B

Thank you, Pecoflyer. Your solution is exactly what I needed. You are indeed an expert.

If your using Excel 2010 as in your profile, why don't you use the AGGREGATE function (Non array) and assuming your data is in column A!

=AGGREGATE(4,6,A:A)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word 2010 cannot find data source	wsdb	Mail Merge	7	09-05-2012 03:16 PM
Cannot find Outlook 2010 data files	COLC	Outlook	4	08-09-2012 06:02 AM
find data	GPENTEZ	Excel	3	01-07-2012 03:41 PM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
How to write a macro to find a specified name in a list of data?	Jaffa	Excel	1	10-23-2010 02:39 PM