LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default if statement or other methds to find similar data

Hello

I have two set of data. I have to match that both contain PCO12345.
All PCO# # # # are different. Majority are in both files but some of
the them are missing. There is no particular order. Is there any way
to find PCO # # # # that are in both files and which ones are
missing? I there any easy method like if statements? other than going
through each finding each PCOnumber one by one. There are 2300+
recods.

thanks in advance
 
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
Find Similar Steve Excel Worksheet Functions 3 April 24th 07 03:56 PM
compare and find similar numbers in two columns New User New Users to Excel 1 October 25th 06 06:59 PM
find similar numbers dune Excel Discussion (Misc queries) 1 March 4th 06 12:12 AM
how to create automatic macro with if statement or similar betatryck_se Excel Discussion (Misc queries) 2 December 14th 05 11:32 AM
IF statement with logical_value that is similar to this 0 Mortgage Man Excel Worksheet Functions 6 August 31st 05 10:51 PM


All times are GMT +1. The time now is 04:22 AM.

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

About Us

"It's about Microsoft Excel"