Prev: Text to Columns Help
Next: Copy to filtered blank rows from another spreadsheet
From: Sarita on 28 Apr 2010 14:44
Hi,

I need to create an if statement or vlookup that will compare both columns
and bring back the results that is not true. I know what matches so
basically I want to see all the data that doesn't match. I want to see the
results of everything in Account II that doesn't match Account. Help
everything I try doesn't work.

Sarita aka non excel expert!!!

Account Account II
154623 154142
154632 154189
154639 154632
154649 154636
154861 154739
154996 154840
155765 154850
155008
155765
155801
155829
159002
160632
160932
160934
166243
166249
166311
166448

From: Narnimar on 28 Apr 2010 15:25
If you are ok if highlight nonmatching cells through conditional format, try
"format only unique or duplicate values"
"Sarita" wrote:

> Hi,
>
> I need to create an if statement or vlookup that will compare both columns
> and bring back the results that is not true. I know what matches so
> basically I want to see all the data that doesn't match. I want to see the
> results of everything in Account II that doesn't match Account. Help
> everything I try doesn't work.
>
> Sarita aka non excel expert!!!
>
> Account Account II
> 154623 154142
> 154632 154189
> 154639 154632
> 154649 154636
> 154861 154739
> 154996 154840
> 155765 154850
> 155008
> 155765
> 155801
> 155829
> 159002
> 160632
> 160932
> 160934
> 166243
> 166249
> 166311
> 166448
>
From: Sarita on 28 Apr 2010 15:49
Thank you for trying but that isn't what I wanted to do. Anyone else have any
other answers?


"Narnimar" wrote:

> If you are ok if highlight nonmatching cells through conditional format, try
> "format only unique or duplicate values"
> "Sarita" wrote:
>
> > Hi,
> >
> > I need to create an if statement or vlookup that will compare both columns
> > and bring back the results that is not true. I know what matches so
> > basically I want to see all the data that doesn't match. I want to see the
> > results of everything in Account II that doesn't match Account. Help
> > everything I try doesn't work.
> >
> > Sarita aka non excel expert!!!
> >
> > Account Account II
> > 154623 154142
> > 154632 154189
> > 154639 154632
> > 154649 154636
> > 154861 154739
> > 154996 154840
> > 155765 154850
> > 155008
> > 155765
> > 155801
> > 155829
> > 159002
> > 160632
> > 160932
> > 160934
> > 166243
> > 166249
> > 166311
> > 166448
> >
From: reza on 29 Apr 2010 02:05
Sarita...

why don't you use countif, after that filter for value 0...

hope this help

"Sarita" wrote:

> Hi,
>
> I need to create an if statement or vlookup that will compare both columns
> and bring back the results that is not true. I know what matches so
> basically I want to see all the data that doesn't match. I want to see the
> results of everything in Account II that doesn't match Account. Help
> everything I try doesn't work.
>
> Sarita aka non excel expert!!!
>
> Account Account II
> 154623 154142
> 154632 154189
> 154639 154632
> 154649 154636
> 154861 154739
> 154996 154840
> 155765 154850
> 155008
> 155765
> 155801
> 155829
> 159002
> 160632
> 160932
> 160934
> 166243
> 166249
> 166311
> 166448
>
 | 
Pages: 1
Prev: Text to Columns Help
Next: Copy to filtered blank rows from another spreadsheet