Thread: extract matching vales
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
  
Posts: 171
Default extract matching vales
I am looking for array formula for
range a2:a1200
Rajiv
Raju
Anita
Rajan
Prem
Ram
extract all the text values from the range that begins with "raj" string(not
case sensitive)
Output results be: Rajiv
Raju
Rajan
Reply With QuoteReply With Quote