LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Comparing two sets of columns

Hi Everyone,

I had a question regarding comparing two sets of data. So for example, i
have a set of data with account numbers and payment amounts. I want to
compared a loan amount and a payment amount from another data set to
determine if there is a match on both criteria.

Loan number Payment Amount
12345 100
45678 200
95844 300

I want excel to check to see if loan numbers and payment amounts from
another set match the one i have.

thanks
 
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
Comparing two different sets of data with common element tutaref Excel Worksheet Functions 1 April 5th 07 08:24 PM
Comparing two columns of information with 2 new columns of informa cbuck Excel Discussion (Misc queries) 1 January 16th 07 09:49 PM
Combining information in sets of columns Ken Excel Discussion (Misc queries) 1 July 29th 06 08:10 AM
Comparing two sets data for different month achilles Excel Discussion (Misc queries) 0 February 9th 06 02:44 PM
help comparing two sets od data to find the odd data matsgullis Excel Worksheet Functions 2 January 12th 06 01:52 AM


All times are GMT +1. The time now is 05:04 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"