Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare Two columns
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I compare tow columns of numbers? | Excel Discussion (Misc queries) | |||
Excel Formula or tool to compare two columns of data | Excel Worksheet Functions | |||
Compare multiple column of data and list out common and unique component in adj columns | Excel Worksheet Functions | |||
Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions |