| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
compare data from 2 columns
I need a formula that will allow me to search a column (B1:B19989) that
contains text with the data from a column (A1:A32417) that contains a list of part numbers and display a result(True/False) into another column (C). Column B's text has the part numbers mixed in with the text. I need to know which numbers from column A are found within the text of column B. I have tried many of the example sulutions from this group and cannot get them to work. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
