i appreciate your help it currently works i kinda am nit picking now to see
if anyone else has any ideas.
--



"RagDyeR" wrote:

Just revise and use the array formula I gave you yesterday for your other
"auto-sort" thread.

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"bkunes" wrote in message
...
i know i can do that and create an auto matic sort using rank and v lookup,
but how do i get the entire row to follow that individual column
--



"Don Guillett" wrote:

OR
assign 1 and 2 instead and just sort ascending?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bkunes" wrote in message
...
i have done a search and assigned either a 1 or a 0 to each row, 1's are
matches. i want to create a sort that will take all the matches and all
their coressponding data in each adjacent column to the top of the
sheet.
so
in other word if there is a 1 move the entire row to the top of the
sheet.
however, i cannot use the <data, <sort option because i need the sort
to
be
automatic, because i will be completeing different searches often,
therefore
data will change frequently.


A B C D
E F
0 SC677-0001-54.63 26.3125 2 0.5 45/45
0 SC704-0001-54.63 27.3125 0 3 90/90
1 SC862-0001-54.63 27.3125 0 3 90/90
0 SC884-0001-54.63 27.3125 0 0.375 45/45
1 SC917-0001-77.76 38.88125 0 0 90/90

thanks in advance
--