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

Macro to Select text from a point given to a specific word 2
External cell reference between two excel worksheets both in One Drive 0
Remove Identical words 0
formula to compare a values and return 2
Link a text box based on drop down box with four options MS Word 365 0
linking a range of cells (=) to another range 4
conditional if loop 0
Compare 1 cell to column of cells returning adjacent cells info? 1

Top