|  | Compare columns | | |
| | | gary |  |
|  Posted: Sat Aug 30, 2008 8:17 pm Post subject: Compare columns |  |
How do I determine whether the data in COL A exists COL B?
How do I determine whether the data in COL A does NOT exist in COL B? |
| |
| | | smartin | |
| | Posted: Sat Aug 30, 2008 8:17 pm Post subject: Re: Compare columns | |
gary wrote:
| Quote: | How do I determine whether the data in COL A exists COL B?
=COUNTIF(B:B,A1)>0 |
| Quote: | How do I determine whether the data in COL A does NOT exist in COL B?
=COUNTIF(B:B,A1)=0 |
|
| |
| | | AltaEgo | |
| | Posted: Sun Aug 31, 2008 12:46 am Post subject: Re: Compare columns | |
You could use conditional formatting:
1) Click on cell A1
2) Click format, conditional formatting
3) Change Condition 1 to 'formula is'
4) Enter '=COUNTIF(B:B,A1)>0' into the formula space (without quotes)
5) Click the [Format] button and the 'Patterns' tab
6) Choose a colour
7) Click [OK]
 Click the format painter
9) Click the 'A' at the top of column A
Everything that is highlighted in the colour of your choice is listed in
column B. Everything not coloured is not in column B:
If you need further help, try LINK under
headings 'conditional formatting'
--
Steve
"gary" <gcotterl@co.riverside.ca.us> wrote in message
news:f38db82f-0b95-4de8-8b60-82256e656666@z6g2000pre.googlegroups.com...
| Quote: | How do I determine whether the data in COL A exists COL B?
How do I determine whether the data in COL A does NOT exist in COL B?
|
|
| |
|
|
