View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Larryq22 Larryq22 is offline
external usenet poster
 
Posts: 13
Default Sorting by format - is it possible?

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