Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match, Exact? NA error
060724 Match, Exact? NA error
hi, trying to make an "exact" match for the case, of a character, e.g.: "A" where the following works, am trying to isolate capital "A"'s. =MATCH("A",$AE$1:$AE$1299,0) the following receives a NA error. Is there a correct way to represent? am open to inserting IF statements, EXACT, or ROW<=().. etc. =MATCH(EXACT($AE$1:$AE$1299,"A"),$AE$1:$AE$1299,0) example of an EXACT, that was able to get to work in combo with other: =SUMPRODUCT(--(EXACT(LEFT($AE$112:$AE$1300,1),"A"))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MATCH function, exclusion question | Excel Discussion (Misc queries) | |||
Standard Error Bars. | Excel Discussion (Misc queries) | |||
How to obtain both std dev and std error mean in each y error bar | Excel Worksheet Functions | |||
Match name not exact | Excel Worksheet Functions | |||
ERROR | Excel Discussion (Misc queries) |