When you said "I can't use the filter to do it". Do you mean, you are not
allowed to use it or you don't want to use it or it doesn't works when you
use it

To me, the easiest way is to use AutoFilter.

"Jamie" wrote:

Hello

I have list that i need to sort and a I can't use the filter to do it, I
want to use formulas to do it. What i want to do is use a formula to take all
the rows that have Table No "1" and display them starting in say column G. I
have been trying offsets, and lookups but I struggling with this. I can't get
the filter to work the way I want either. Any help would be appreciated

A B C D E

1 Table No. H Q Start Date End Date
2 1 2.5 25 2006-05-14 2005-06-14
3 1 3.5 35 2006-05-14 2005-06-14
4 2 3.0 30 2006-10-14 2005-12-14
4 2 4.0 40 2006-10-14 2005-12-14