Thread: Sorting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
OfficeNDN OfficeNDN is offline
external usenet poster
 
Posts: 22
Default Sorting

I am sorting by the following


=ISNA(MATCH(D2,$P$2:$P$2500,FALSE))

is the formula that is in cell y2.

=ISNA(MATCH(P2,$D$2:$D$2500,FALSE))

is the formula that is in cell z2.

What I would like to know is there anyway I can all the "TRUE" values to be
listed first and the "FALSE" values to be listed after those?