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: 3
Default Comparing pairs of cells in four columns

I am trying to compare four columns of text, say A-D, such that if the paired
combination of cells A2 and B2 can be found as a combination of the same pair
text ANYWHERE in columns C and D, I would get "true". I.e., I want to search
for all the A+B combos in corresponding C+D columns
example:

A B C D E
1 oak tree bird dog true
2 gold brick oak brick false
3 dumb bunny oak tree false

The process found the combination for A1+B1 in C3+D3; I would want to do
the same for gold+brick and dumb+bunny, etc.etc. Geez I'm worn out trying
different combos of "logic."
 
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 text within cells in two columns Billing Excel Worksheet Functions 2 April 30th 07 02:00 PM
comparing cells in two columns ? TimR Excel Discussion (Misc queries) 3 February 10th 07 08:17 AM
Sum product of many pairs of columns KeenKiwi Excel Worksheet Functions 3 May 11th 06 12:59 PM
Removing Duplicate Pairs(2 Columns) deathswan Excel Discussion (Misc queries) 3 April 1st 06 05:01 AM
chart with stacked columns in pairs beardedoldness Charts and Charting in Excel 1 January 9th 06 08:50 PM


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