LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tommy
 
Posts: n/a
Default Compare Data

Let's say I want to compare data thusly:

I have two columns of numbers, G and N. Column G has more numbers than
column N, and includes every number in column N.

In each cell in column O is a string associated with the number in column N.
I want to comare a number in column N with all the numbers in column G and
when I find a match, copy the string in column O to the appropriate cell in
column M. I want to repeat this process until all the strings in column O
have been matched to their numbers in column G.

Whew! So. How do I do this?

Thanks,

Tommy
 
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
How do I compare data in two worksheets to find matching cells? Gary Excel Discussion (Misc queries) 4 March 2nd 06 09:04 PM
compare worksheets data find data that changed Excel Discussion (Misc queries) 3 September 19th 05 09:43 PM
Trying to compare data from 2 different sources borkot01 Excel Discussion (Misc queries) 2 August 3rd 05 08:55 PM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM
How can I compare two lists of data (channel lineups) - find what. mf4852 Excel Worksheet Functions 3 February 6th 05 04:59 PM


All times are GMT +1. The time now is 11:19 PM.

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"