Creating Multiple Filters in the same columns without using tables

[greenguy55]

The title explains most of what I want to know, is there a way to create multiple filters on the same excel sheet, in the same columns without the use of tables. This would be to filter multiple sets of data to determine who is leading over others on a simple report. In this case I would need to be able to filter both top and bottom sets of data.

	Team Leader	Team	D Goal	D Actual	A Goal	A Actual	%	% D	% A
	Person 1	Team 1	50875	59527	1778	1963	3.30%	117.00%	110.40%
	Person 2	Team 2	50877	56862	1732	1908	3.36%	111.76%	110.16%
	Person 3	Team 3	62785	69293	2170	2229	3.22%	110.36%	102.71%
	Person 4	Team 4	61051	66967	2168	2219	3.31%	109.69%	102.35%
	Person 5	Team 5	61647	64204	2197	2220	3.46%	104.14%	101.04%
	Person 6	Team 6	61057	57338	2091	1877	3.27%	93.90%	89.76%
	Person 7	Team 7	59915	58894	2037	1702	2.89%	98.29%	83.55%
	Person 8	Team 8	66127	70261	2228	1818	2.59%	106.25%	81.59%
	Person 9	Team 9	61060	60484	2104	1704	2.82%	99.05%	80.98%
	Person 10	Team 10	53173	51023	1826	1464	2.87%	95.95%	80.17%
	Person 11	Team 11	58237	56541	2041	1581	2.80%	97.08%	77.46%
	Person 12	Team 12	64492	62469	2103	1583	2.53%	96.86%	75.27%
	Person 13	Team 13	60477	50627	2096	1407	2.78%	83.71%	67.12%
	Person 14	Team 14	62232	44763	2093	1271	2.84%	71.92%	60.72%
	Person 1	Team 1	295134	293466	10140.00	8698	2.96%	99.43%	85.77%
	Person 2	Team 2	229065	224606	7867.00	6927	3.08%	98.05%	88.05%
	Person 3	Team 3	309806	311181	10657.00	9321	3.00%	100.44%	87.46%
	Total		834005	829253	28664.00	24946	3.01%	97.48%	85.30%

<tbody>
</tbody>

 

[BrianJN1]

That is quite a neat table and certainly has taken you much time to assemble.

Unfortunately it may tell you most of what you want to know I'm afraid that it leaves me with many questions.
Firstly, what is the significance of "Team Ldr" and "Team"? Your table suggest that may be ignored.
Secondly, has the lower table been derived from the top table?
If so, what criteria has been used?
Thirdly, some concept of how the maths across the columns (and even downwards) is probably imperative.

 

[greenguy55]

Thank you for responding! For the sake of this question, all I am looking for is a way to create multiple active filters in different ranges but also located in the same columns. It does seem like a simple question to answer and maybe it is, but I haven't found a way to do this without the use of tables, the reason I do not want to use other tabs or different locations of the worksheet are for reporting and visibility purposes - i.e. it needs to look simple enough to understand. You can pretty much disregard the table given it is just there to give an idea of two sets of data in the same columns and where I want two active filters to be.

 

[BrianJN1]

You haven't defined what filtering you require.

I asked those questions to gain some concept so that either myself or some other know precisely what we are to do.