flitering

Hay guys i have an interesting little thing going on here. I have a spreadsheet that I have so kindly attached that I want to filter by the department that I click on from the drop down menu. I hope this makes sense. If it does not give me a shout back and I will try to explain in a little better detail.

See the attached file.

It may do what you need.

Regards,
Antonio

That does it...now how would i be able to keep a space in the results table. Take a look at the two screen shots that I have posted...to get a better explanation.

Guys how can i make it stop filtering on a row. I want it to filter on some values under the department heading. Please take a look at the spreadsheet that i have attached.

See the attached file... I hope it's what you want.

Regards
Antonio

That is exactly what I want ...but when i click on the department that I want to sort by i come up with different values. It should come up with the same values but it does not always do that. hrmmm...try testing it out you will see what i mean...