My data such as (Row1-3, ColumnA-E) is a set of data, next set is Row4-6,
ColumnA-E....and so on.

Now I add column F as a priority indicator, such as 1, 2, 3............
Now if I want to sort those data, I need fill in Row1-3, Column F with the
same indicator, if I only fill Column F at Row1, Row4, Row7, Row10, the
sorting result will be wrong

Any way any fullfil this request ? (only fill in ar Row 1, 4, 7, 10.......)

Thanks a lot

Hi
I think you will need to use 2 columns, F and G.
In F put the same number against all 3 rows, in G put 1,2,3
Then sort the whole block with the first Key being column F ascending, and
the second key being column G ascending.

Regards

Roger Govier


man wrote:
My data such as (Row1-3, ColumnA-E) is a set of data, next set is Row4-6,
ColumnA-E....and so on.

Now I add column F as a priority indicator, such as 1, 2, 3............
Now if I want to sort those data, I need fill in Row1-3, Column F with the
same indicator, if I only fill Column F at Row1, Row4, Row7, Row10, the
sorting result will be wrong

Any way any fullfil this request ? (only fill in ar Row 1, 4, 7, 10.......)

Thanks a lot