Thread: COMPARING TEXT IN A RANGE OF CELLS AND DISPLAY IT IN ANOTHER.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
  
Posts: 2,069
Default COMPARING TEXT IN A RANGE OF CELLS AND DISPLAY IT IN ANOTHER.
Hi
I am working on two sheets. the one sheet is used to update account numbers
and is generated from another program. I need a function to find text from a
range of cells. e.g. searching for BGA158/0002S from
AJB254/0002T,BGA158/0002S,DEG536/0002T; IF FOUND FROM THE RANGE OF CELLS IN A
SHEET MUST DISPLAY ON THE ANOTHER SHEET
Reply With QuoteReply With Quote