PC Review


Reply
Thread Tools Rate Thread

Compare Two columns

 
 
=?Utf-8?B?SmF2eUQ=?=
Guest
Posts: n/a
 
      19th Sep 2006
Hello,

I tried to figure this out, seems to me that I'm getting close

I need the formula to look at column AA see if it says O or U, then look at
Column AB and see if it says O or U, then if they both meet this criteria,
then return 1 in AC,

this is what I have so far,

=IF(OR(AA26={"O","U"},AB26={"O","U"}),"1",""), I'm probably off, but it
seems to have started to do something. I was using the And function, but
running out of time.

Regards, thanks to all in advance.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare columns gary Microsoft Excel Discussion 1 31st Aug 2008 03:46 AM
compare columns Bob Microsoft Excel Worksheet Functions 1 7th Apr 2008 10:56 PM
Compare columns =?Utf-8?B?UGF0cmljayBCYXRlbWFu?= Microsoft Excel Programming 1 23rd Nov 2007 12:22 PM
Narly one...compare columns with other columns beatrice25 Microsoft Excel Misc 7 4th Jun 2006 09:43 PM
compare columns =?Utf-8?B?Zmx1ZmZ5?= Microsoft Excel Worksheet Functions 3 10th Mar 2006 03:59 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:40 PM.