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