brand

Hello, I am trying to get at some cross buying behavior from a large data set that I have. Here is simple, example of the Pivot Table I have put together so far: <tbody> Brand A Brand B Brand C Brand D John 1 2 Mark 1 Amy 1 1 </tbody> Essentially I am trying to put together a...

Hi, I've tried to come up with this code but it won't work - can anyone advice please? Trying to make a button that will hide and unhide the sheets below however need it to be very hidden.. I can make it work with normal hidden but this allows the user to unhide manually which I don't want to...

I have a pivot table that needs a chart from part of it (My Brand). The pivot table is made up of Market data and my brand data where the result shows %Of. This means that if I attempt to hide market data the whole thing collapses. I just want the chart to Show my Brand %Of figures and due to...

I have the following Data Set: <tbody> 1 Brand ABC 2 MFG Apple 3 Overivew1 4 Overview2 5 Brand DEF 6 MFG Peach 7 Overview1 8 Overview2 9 Brand XYZ 10 MFG Grape 11 Overview1 12 Overview2 </tbody> I need a user defined function that will look up the brand and place it...

Hello, I need some help from an excel whizz if possible?? Can this be achieved in excel? My bookkeeper has informed me that the following task is beyond his scope!! Objective: Populate Worksheet 3 with a list of all current active products listing the product name, brand name, quantity of...

Dear Team, Need help. I have around 500 cost centres. We maintain a matrix to allocate amounts from each cost centers to various brands based on a percentage set by management. Now I need to pull out cost for each brands for these cost centres based on the % matrix. Here is a sample data, please...