View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
 
Posts: 383
Default 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")))