There was a :) in the post

Anyway it now seems filtering would be a better option for the OP as other
age sets maybe needed

Regarding speed - it takes you back to the old days of data processing -
when a little thought was needed.
these days the usual approach is to find/stumble across something that
works then use it on large sets of data in just the same way.

Steve

On Tue, 15 Aug 2006 15:12:09 +0100, Bernie Deitrick <deitbe consumer dot
org wrote:

Steve,

Putting them back is trivial. If it is important, you simply re-sort on
another column, or if there
isn't a column to base the sort on, you add another column through with
the original row number to
allow re-sorting. But the speed gain can be up to 1000 times, given
testing that I have done
previously.

Bernie
MS Excel MVP


"SteveW" wrote in message
news:op.tebvu5srevjsnp@enigma03...
Neat.

Now put the other rows back where they were :)

Steve






--
Steve (3)