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?
|