Auto Filter Qestion

[Dragonwolf]

I'm using the auto-filter for a list and was wondering if i can have it set up to filted by only 2 columns. For example auto filter uses all five column but i only want it to arrange by "Team" and "Date" is there any way to do that?

Team	Date	Actual	Adjust	M Avg
A Team	17-Feb	40,456	40,456	4,495
B Team	17-Feb	45,653	47,451	3,804
A Team	18-Feb	47,713	47,713	5,964
B Team	18-Feb	40,993	40,993	5,124

<colgroup><col style="width: 48pt;" width="64"> <col style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717;" width="129"> <col style="width: 97pt; mso-width-source: userset; mso-width-alt: 4717;" span="3" width="129"> <tbody>
</tbody>

 

[braindiesel]

If the term "Team" is in A1 and Date is in B2, select A1:B2 and click Autofilter

 

[Dragonwolf]

I AM A DUNCE thanks Braindiesel im going to bang my head on the wall now

 

[braindiesel]

No problem... my answer should have said A1 and B1 to make any sense anyway... must be a Monday

 

[Dragonwolf]

lol it is it is