Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 20th 06, 03:40 PM posted to microsoft.public.excel.worksheet.functions
micmed
 
Posts: n/a
Default 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

  #2   Report Post  
Old January 20th 06, 04:12 PM posted to microsoft.public.excel.worksheet.functions
Stephen
 
Posts: n/a
Default compare data from 2 columns

Have you tried the vlookup function?

"micmed" wrote:

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

  #3   Report Post  
Old January 20th 06, 04:28 PM posted to microsoft.public.excel.worksheet.functions
micmed
 
Posts: n/a
Default compare data from 2 columns

Yes I have but can't seem to get the syntax right. I keep getting the #N/A
error.

"Stephen" wrote:

Have you tried the vlookup function?

"micmed" wrote:

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

  #4   Report Post  
Old February 13th 06, 02:53 AM posted to microsoft.public.excel.worksheet.functions
Support Texteer
 
Posts: n/a
Default compare data from 2 columns

If possible you can change the columns into text file,then you can try
Texteer software at: http://www.texteer.com
It provides several functions in which "Include Compare" function maybe
can solve your problem.The quote
page:http://www.texteer.com/windows/b0.sb1.1.htm



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Data in narrow columns truncated when saving as DBF Ben Amada Excel Discussion (Misc queries) 2 October 11th 05 11:23 PM
Compare data in two columns to find duplicates. Dan Excel Discussion (Misc queries) 2 October 5th 05 04:42 AM
sort column data with hidden columns - excel 2003 nanimadrina Excel Discussion (Misc queries) 2 April 26th 05 08:27 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017