COMPARING TEXT IN A RANGE OF CELLS AND DISPLAY IT IN ANOTHER.

J

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
linking a range of cells (=) to another range 4
Referencing text in merged cells 1
using the =page! feature to transpose a row to column 0
Excel Count number of instances in a column 1
RANGE EXCEL copy cell that meets criteria in a range 3
Comparing the first 2 characters of a coloumn to a string 1
sum of visable cells in filtered range 7

Top