Prev: Zero's plotted in chart?
Next: Working With Dates in Excel
From: MMcGee on 25 May 2010 17:17
Thanks so much to everyone for your help! It appears that Mr. Skaria's
formula solved my problem. Thanks again kind sir!

Regards

"Jacob Skaria" wrote:

> In sheet2 cell B1 apply the below formula and copy down as required...Will
> return names which are not there in Sheet1 ColA.
>
> =IF(COUNTIF(Sheet1!A:A,A1),"",A1)
>
> OR ' handling blank entries in ColA
>
> =IF(OR(A1="",COUNTIF(Sheet1!A:A,A1)),"",A1)
>
> --
> Jacob (MVP - Excel)
>
>
> "MMcGee" wrote:
>
> >
> > I have 2 worksheets. Column A in sheet 1 contains values that I know are in
> > column A of sheet 2. I need only the rest of the values in sheet 2 (in other
> > words, the values that are NOT in sheet one).
> >
> >
> > Thanks!
> >
> >
First  |  Prev  | 
Pages: 1 2
Prev: Zero's plotted in chart?
Next: Working With Dates in Excel