Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
match #n/a problem
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
match #n/a problem
If your error messages appear in cells in column A then
type formula in column be saying =if(isna(A2),0,a2) If the "N/A" is being caused as a result of a lookup then change the lookup formula to read =if(isna(vlookup (A2,lookuprange,columntoreturn,0)),0,vlookup (A2,lookuprange,columntoreturn,0)) where lookuprange is the table you looked up and columntoreturn is the column number containing the value you want to return. To find the row of the range containing the highest number then type in =max(range). Hope this helps. -----Original Message----- I have a range of cells selected. Within that range is some "#N/A" and numbers. I am wanting to find the row of the largest number in the range. Thanks in advance. -- . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
match #n/a problem
Try something like
=MAX(IF(ISNUMBER(A1:A10),A1:A10)) array entered with ctrl + shift & enter regards, Peo Sjoblom -----Original Message----- I have a range of cells selected. Within that range is some "#N/A" and numbers. I am wanting to find the row of the largest number in the range. Thanks in advance. -- . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH problem | Excel Worksheet Functions | |||
MATCH problem | Excel Worksheet Functions | |||
Match Problem | Excel Discussion (Misc queries) | |||
match problem | Excel Worksheet Functions | |||
ugh! Match/Index problem | Excel Programming |