(Msg. 1) Posted: Fri Nov 06, 2009 5:34 am
Post subject: Sorting by format - is it possible? Archived from groups: microsoft>public>excel>misc (more info?)
Hello. I used the following formula to highlight numbers in Column B which
were not in Column A: =(COUNTIF($A:$A,B1)=0)*(B1<>"")
Now I want to resort the list in B so that the highlighted numbers are at
the top. How can I do this?
Or - if there's a better way, I'm open to that too.
(Msg. 2) Posted: Fri Nov 06, 2009 5:45 am
Post subject: RE: Sorting by format - is it possible? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You have already done 90% of the work.
Put your conditional formatting formula in column C and then sort A & B & C
by C.
--
Gary''s Student - gsnu200908
"Larryq22" wrote:
> Hello. I used the following formula to highlight numbers in Column B which
> were not in Column A: =(COUNTIF($A:$A,B1)=0)*(B1<>"")
>
> Now I want to resort the list in B so that the highlighted numbers are at
> the top. How can I do this?
>
> Or - if there's a better way, I'm open to that too.
>
> Thanks,
> Larry
> Lexington, KY
>
(Msg. 3) Posted: Fri Nov 06, 2009 5:46 am
Post subject: RE: Sorting by format - is it possible? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Rather than a CF, create a helper column with that same formula. Then sort by
that.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Larryq22" wrote:
> Hello. I used the following formula to highlight numbers in Column B which
> were not in Column A: =(COUNTIF($A:$A,B1)=0)*(B1<>"")
>
> Now I want to resort the list in B so that the highlighted numbers are at
> the top. How can I do this?
>
> Or - if there's a better way, I'm open to that too.
>
> Thanks,
> Larry
> Lexington, KY
>
(Msg. 4) Posted: Fri Nov 06, 2009 8:00 am
Post subject: RE: Sorting by format - is it possible? [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Sorry for being dense, but can you explain how to do this? Do I highlight
column C, put the CF formula in the CF dialog box? Then I'm not sure what
you mean by "sort by C".
"Gary''s Student" wrote:
> You have already done 90% of the work.
>
> Put your conditional formatting formula in column C and then sort A & B & C
> by C.
> --
> Gary''s Student - gsnu200908
>
>
> "Larryq22" wrote:
>
> > Hello. I used the following formula to highlight numbers in Column B which
> > were not in Column A: =(COUNTIF($A:$A,B1)=0)*(B1<>"")
> >
> > Now I want to resort the list in B so that the highlighted numbers are at
> > the top. How can I do this?
> >
> > Or - if there's a better way, I'm open to that too.
> >
> > Thanks,
> > Larry
> > Lexington, KY
> >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office