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

		Microsoft Office Forums > Microsoft Excel > Excel
Find MAX value in data containing '#N/A'

FAQ

Thread Tools

Display Modes

10-29-2013, 05:20 AM

Pecoflyer

Windows 7 64bit Find MAX value in data containing '#N/A'

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Perhaps following array formula

Code:

=MAX(IF(NOT(ISNA($A$1:$A$50)),($A$1:$A$50)))

Commit with Ctrl+Shift+Enter

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Tags

#na, max()

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

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