Creating Multiple Filters in the same columns without using tables

G

greenguy55

New Member
Joined
Jul 27, 2017
Messages
2
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.

[TABLE="width: 603"]
<tbody>[TR]
[TD="class: xl66, width: 153, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, width: 98, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 95, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 54, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 59, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 59, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 52, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 40, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 82, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 55, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, width: 56, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl81, bgcolor: #ED7D31"]Team Leader
[/TD]
[TD="class: xl80, bgcolor: #ED7D31"]Team
[/TD]
[TD="class: xl80, bgcolor: #ED7D31"]D Goal
[/TD]
[TD="class: xl82, bgcolor: #70AD47"]D Actual
[/TD]
[TD="class: xl80, bgcolor: #ED7D31"]A Goal
[/TD]
[TD="class: xl82, bgcolor: #70AD47"]A Actual
[/TD]
[TD="class: xl119, bgcolor: #70AD47"]%
[/TD]
[TD="class: xl73, bgcolor: #70AD47"]% D
[/TD]
[TD="class: xl74, bgcolor: #70AD47"]% A
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 1
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 1
[/TD]
[TD="class: xl115, bgcolor: white"]50875
[/TD]
[TD="class: xl116, bgcolor: #F2F2F2"]59527
[/TD]
[TD="class: xl117, bgcolor: white"]1778
[/TD]
[TD="class: xl116, bgcolor: #F2F2F2"]1963
[/TD]
[TD="class: xl118, bgcolor: #F2F2F2"]3.30%
[/TD]
[TD="class: xl71"]117.00%
[/TD]
[TD="class: xl72"]110.40%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 2
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 2
[/TD]
[TD="class: xl83, bgcolor: #D5EFFF"]50877
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]56862
[/TD]
[TD="class: xl84, bgcolor: #D5EFFF"]1732
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]1908
[/TD]
[TD="class: xl77, bgcolor: #9BD9FF"]3.36%
[/TD]
[TD="class: xl70"]111.76%
[/TD]
[TD="class: xl69"]110.16%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 3
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 3
[/TD]
[TD="class: xl68, bgcolor: white"]62785
[/TD]
[TD="class: xl78, bgcolor: #F2F2F2"]69293
[/TD]
[TD="class: xl75, bgcolor: white"]2170
[/TD]
[TD="class: xl78, bgcolor: #F2F2F2"]2229
[/TD]
[TD="class: xl79, bgcolor: #F2F2F2"]3.22%
[/TD]
[TD="class: xl70"]110.36%
[/TD]
[TD="class: xl69"]102.71%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 4
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 4
[/TD]
[TD="class: xl83, bgcolor: #D5EFFF"]61051
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]66967
[/TD]
[TD="class: xl84, bgcolor: #D5EFFF"]2168
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]2219
[/TD]
[TD="class: xl77, bgcolor: #9BD9FF"]3.31%
[/TD]
[TD="class: xl70"]109.69%
[/TD]
[TD="class: xl69"]102.35%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 5
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 5
[/TD]
[TD="class: xl68, bgcolor: white"]61647
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]64204
[/TD]
[TD="class: xl75, bgcolor: white"]2197
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]2220
[/TD]
[TD="class: xl109, bgcolor: #D9D9D9"]3.46%
[/TD]
[TD="class: xl70"]104.14%
[/TD]
[TD="class: xl69"]101.04%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 6
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 6
[/TD]
[TD="class: xl68, bgcolor: white"]61057
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]57338
[/TD]
[TD="class: xl75, bgcolor: white"]2091
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]1877
[/TD]
[TD="class: xl109, bgcolor: #D9D9D9"]3.27%
[/TD]
[TD="class: xl70"]93.90%
[/TD]
[TD="class: xl69"]89.76%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 7
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 7
[/TD]
[TD="class: xl68, bgcolor: white"]59915
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]58894
[/TD]
[TD="class: xl75, bgcolor: white"]2037
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]1702
[/TD]
[TD="class: xl109, bgcolor: #D9D9D9"]2.89%
[/TD]
[TD="class: xl70"]98.29%
[/TD]
[TD="class: xl69"]83.55%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 8
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 8
[/TD]
[TD="class: xl68, bgcolor: white"]66127
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]70261
[/TD]
[TD="class: xl75, bgcolor: white"]2228
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]1818
[/TD]
[TD="class: xl109, bgcolor: #D9D9D9"]2.59%
[/TD]
[TD="class: xl70"]106.25%
[/TD]
[TD="class: xl69"]81.59%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 9
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 9
[/TD]
[TD="class: xl68, bgcolor: white"]61060
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]60484
[/TD]
[TD="class: xl75, bgcolor: white"]2104
[/TD]
[TD="class: xl107, bgcolor: #D9D9D9"]1704
[/TD]
[TD="class: xl109, bgcolor: #D9D9D9"]2.82%
[/TD]
[TD="class: xl70"]99.05%
[/TD]
[TD="class: xl69"]80.98%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 10
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 10
[/TD]
[TD="class: xl68, bgcolor: white"]53173
[/TD]
[TD="class: xl78, bgcolor: #F2F2F2"]51023
[/TD]
[TD="class: xl75, bgcolor: white"]1826
[/TD]
[TD="class: xl78, bgcolor: #F2F2F2"]1464
[/TD]
[TD="class: xl79, bgcolor: #F2F2F2"]2.87%
[/TD]
[TD="class: xl70"]95.95%
[/TD]
[TD="class: xl69"]80.17%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 11
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 11
[/TD]
[TD="class: xl83, bgcolor: #D5EFFF"]58237
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]56541
[/TD]
[TD="class: xl84, bgcolor: #D5EFFF"]2041
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]1581
[/TD]
[TD="class: xl77, bgcolor: #9BD9FF"]2.80%
[/TD]
[TD="class: xl70"]97.08%
[/TD]
[TD="class: xl69"]77.46%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 12
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 12
[/TD]
[TD="class: xl83, bgcolor: #D5EFFF"]64492
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]62469
[/TD]
[TD="class: xl84, bgcolor: #D5EFFF"]2103
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]1583
[/TD]
[TD="class: xl77, bgcolor: #9BD9FF"]2.53%
[/TD]
[TD="class: xl70"]96.86%
[/TD]
[TD="class: xl69"]75.27%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 13
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 13
[/TD]
[TD="class: xl83, bgcolor: #D5EFFF"]60477
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]50627
[/TD]
[TD="class: xl84, bgcolor: #D5EFFF"]2096
[/TD]
[TD="class: xl76, bgcolor: #9BD9FF"]1407
[/TD]
[TD="class: xl77, bgcolor: #9BD9FF"]2.78%
[/TD]
[TD="class: xl70"]83.71%
[/TD]
[TD="class: xl69"]67.12%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl113, bgcolor: white"]Person 14
[/TD]
[TD="class: xl114, bgcolor: #F2F2F2"]Team 14
[/TD]
[TD="class: xl68, bgcolor: white"]62232
[/TD]
[TD="class: xl78, bgcolor: #F2F2F2"]44763
[/TD]
[TD="class: xl75, bgcolor: white"]2093
[/TD]
[TD="class: xl78, bgcolor: #F2F2F2"]1271
[/TD]
[TD="class: xl79, bgcolor: #F2F2F2"]2.84%
[/TD]
[TD="class: xl70"]71.92%
[/TD]
[TD="class: xl69"]60.72%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl67, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl67, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl101, bgcolor: #0070C0"]Person 1
[/TD]
[TD="class: xl102, bgcolor: #9BD9FF"]Team 1
[/TD]
[TD="class: xl92, bgcolor: #D5EFFF"]295134
[/TD]
[TD="class: xl91, bgcolor: #9BD9FF"]293466
[/TD]
[TD="class: xl93, bgcolor: #D5EFFF"]10140.00
[/TD]
[TD="class: xl91, bgcolor: #9BD9FF"]8698
[/TD]
[TD="class: xl95, bgcolor: #9BD9FF"]2.96%
[/TD]
[TD="class: xl96, bgcolor: #9BD9FF"]99.43%
[/TD]
[TD="class: xl97, bgcolor: #9BD9FF"]85.77%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl101, bgcolor: #0070C0"]Person 2
[/TD]
[TD="class: xl102, bgcolor: #9BD9FF"]Team 2
[/TD]
[TD="class: xl99, bgcolor: white"]229065
[/TD]
[TD="class: xl103, bgcolor: white"]224606
[/TD]
[TD="class: xl100, bgcolor: white"]7867.00
[/TD]
[TD="class: xl103, bgcolor: white"]6927
[/TD]
[TD="class: xl104, bgcolor: white"]3.08%
[/TD]
[TD="class: xl105, bgcolor: white"]98.05%
[/TD]
[TD="class: xl106, bgcolor: white"]88.05%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl101, bgcolor: #0070C0"]Person 3
[/TD]
[TD="class: xl102, bgcolor: #9BD9FF"]Team 3
[/TD]
[TD="class: xl89, bgcolor: white"]309806
[/TD]
[TD="class: xl108, bgcolor: #D9D9D9"]311181
[/TD]
[TD="class: xl90, bgcolor: white"]10657.00
[/TD]
[TD="class: xl108, bgcolor: #D9D9D9"]9321
[/TD]
[TD="class: xl110, bgcolor: #D9D9D9"]3.00%
[/TD]
[TD="class: xl111, bgcolor: #D9D9D9"]100.44%
[/TD]
[TD="class: xl112, bgcolor: #D9D9D9"]87.46%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl81, bgcolor: #ED7D31"]Total
[/TD]
[TD="class: xl85, bgcolor: #FFCC99"][/TD]
[TD="class: xl86, bgcolor: white"]834005
[/TD]
[TD="class: xl88, bgcolor: #FFCC99"]829253
[/TD]
[TD="class: xl87, bgcolor: white"]28664.00
[/TD]
[TD="class: xl88, bgcolor: #FFCC99"]24946
[/TD]
[TD="class: xl94, bgcolor: #FFCC99"]3.01%
[/TD]
[TD="class: xl98, bgcolor: #FFCC99"]97.48%
[/TD]
[TD="class: xl94, bgcolor: #FFCC99"]85.30%
[/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl66, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[TD="class: xl65, bgcolor: #F9F2E7"][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
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.
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,893
Messages
6,175,246
Members
452,623
Latest member
cliftonhandyman

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top