Filtering Challenge

M

MrMel76

New Member
Joined
Apr 14, 2019
Messages
6
Business UnitClusterCountryCategorySubcategorySegmentMarketSectorSubSectorBrandProductnumberSalesTurnoverCostProfitTurnover per pieceCost per pieceProfit per piece
EuropeUK & IrelandIrelandFastfood & DrinksRefreshmentsBurgersEventsFestivalsOutdoorOYT1231002000750125020,007,5012,50
EuropeUK & IrelandIrelandFastfood & DrinksFast FoodSodaEventsFestivalsOutdoorTB456175150010005008,575,712,86
EuropeUK & IrelandIrelandFastfood & DrinksRefreshmentsSodaEventsFestivalsOutdoorRTD789225175012005507,785,332,44
EuropeUK & IrelandUnited KingdomFastfood & DrinksRefreshmentsSodaEventsFestivalsOutdoorOYT1233005002502501,670,830,83
EuropeUK & IrelandUnited KingdomFastfood & DrinksFast FoodBurgersEventsFestivalsOutdoorTB4565503751352400,680,250,44
EuropeUK & IrelandUnited KingdomFastfood & DrinksRefreshmentsSodaEventsFestivalsOutdoorRTD789600,512557005552,091,170,92
EuropeCEECyprusVariety SaucesRefreshmentsSodaEventsFestivalsOutdoorOYT1475010050502,001,001,00
EuropeCEECyprusVariety SaucesFast FoodBurgersEventsFestivalsOutdoorTB258257545303,001,801,20
EuropeCEECyprusVariety SaucesRefreshmentsSodaEventsFestivalsOutdoorRTD3693512035853,431,002,43
EuropeBNLBelgiumVariety SaucesSaucesSweetHomeSummerMildOYT74150080004000400016,008,008,00
EuropeBNLBelgiumVariety SaucesSaucesSweetHomeSummerHotTB852800120005500650015,006,888,13
EuropeBNLBelgiumVariety SaucesSaucesSourHomeSummerX-tremeRTD9632503500275075014,0011,003,00

<tbody>
</tbody>


SelectionDropdownSelectionDropdownSelectionDropdown
Business UnitEuropeBusiness UnitEuropeBusiness UnitEurope
ClusterUK & IrelandClusterUK & Ireland/CEEClusterUK & Ireland/CEE
CountryUnited KingdomCountryUnited Kingdom/CyprusCountryIreland/United Kingdom/Cyprus
CategoryFastfood & DrinksorCategoryFastfood & DrinksorCategoryFastfood & Drinks
SubcategoryRefreshmentsSubcategoryRefreshmentsSubcategoryRefreshments
SegmentSodaSegmentSodaSegmentSoda
MarketEventsMarketEventsMarketEvents
SectorFestivalsSectorFestivalsSectorFestivals
SubSectorOutdoorSubSectorOutdoorSubSectorOutdoor
BrandRTDBrandRTDBrandRTD

<tbody>
</tbody>


So what do I want to do?

Based on my non-unique brand name filter my (financial) data ( productnumber to Profit per piece) based on various header criteria
As an example for my criteria please see the various selection tables. The selection will be done by a dropdown list. I have a formula that makes the row data in the table unique (till brand).That will be the source data for my dropdown

The result of the filtering will become the base for a vlookup.

The path that I want to follow preferably is BU -> Cluster->Country-> Category->Subcategory->Segment->Market->Sector->Subsector. The users for this will be people with minimal excel skill. The will just make a selection and get the output. So I want to make this as simple as possible.

I can do this with slicers BUT I can’t make a dropdown list out of my slicer criteria or I don’t know how.

What is the best way to do this?

Thanks in advance.
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Sort by date Sort by votes
Hi James,

Thanks for your help but I think for what I want to do using slicers will be the most practical way. Too bad I can't make a slicer selection linked to a dropdown list from a different tab. I don't know if its possible in Excel at the moment
 
Upvote 0
Hi James been off the grid for a while and just saw your reply. Much appreciated I will take a look at this..but very much appreciated from my side..you have been a big help
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,214,413
Messages
6,119,374
Members
448,888
Latest member
Arle8907

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