category

Hello all, I am very new to VBA and apologize in advance for the 'simple' question. I am working with thousands of rows of data in a pivot table data sheet where there are 8 categories as shown: <tbody> Month Product ID Product name Sales Rep Product Category Product Brand Quantity Value...

Hello, I have built a sales report dashboard which is to be updated monthly with around 2000 rows of input. The data I input has the following categories/columns: Date | Sales rep | Product | Quantity | Value | Product category | Brand. Sadly, the company's software does not export the...

Hello, I have a workbook which contains a several different tabs all with a different persons stats. i was entering this manually but now i have managed to do an sql dump from the server with all the data i need. i have created a tab called data dump where im going to copy and paste this from...

I am trying to make calculation from my dropdown menu. I have following dropdown in sheet 1 in my excel. <tbody> Category AAA BBB CCC DDD </tbody> In sheet 2, i have corresponding values for this dropdown. <tbody> Category Value AAA 1 BBB 2 CCC 3 DDD 4...

below details are given on Source Code page. How can i scrap these SKUs for all pages in that particular category...

Hi, I tried enough but stuck with this problem. request someone to help:( I have list of 10000 Order Ids in column A, & Customer Name in column B. Order Ids are duplicated, some orders will be 20, some order ids will be 50 etc. In Column C i want to give this data. 5% of order Ids Vs total...

Hey guys, let's say you had to compare a very large group of categories, each with a set of defined traits. The goal is to compare every category against every other category and identify the pairs that are MOST SIMILAR in terms of their trait set. That is, all those category pairs that are...

I have a large dataset (almost 300K rows) with multiple years of information (2003-2016). I'm trying to assign size into a Small, Medium, and Large category by year. My first attempt was to determine the quartiles then manually assign the size to a category but I'm sure there is a more efficient...

I'm new to Power BI. In a simple barchart i want to filter one specific dimension: For planning category A I want to see my data from jan till dec. For planning category B I want to see my data from feb till dec. When i filter using the visual filter i set a filter voor planning category A...

Hi All I have a excel sheet of 80,000 + records There is a column named Category- Which contains a a number code Each category has multiple records Requirement - I want to separate the data into different excel files based on these category code example <tbody> Category Col B Col C Col D...

Hello, I just starting using Power BI and i'm loving the tool. I have a question about following dataset (monthly load into Power BI) <tbody> date categorie account audittrail data 01.01.2019 Q1 Planning Input 15 01.01.2019 Actuals Actual upload 20 01.01.2019 RAF1 Actual upload 10...

Is it possible to write code that clears one slicer based on the selection of another slicer? I have a Category and a Region slicer connected to several charts on a dashboard (in addition to several other slicers too). If I select Category 6 in the Category slicer, I want Excel to auto-clear...

Hello all, I have two worksheets, TW and PP. In TW there is a userform that contains a variety of checkboxes, these determine the information I want to take from PP. There are 12 checkboxes for each month of the year, then four category checkboxes. As an example, if I select CBJAN, CBFEB...

Hello Community, I am trying to match a selected cell to a reference of multiple columns. For my example, I want to choose a state and I want it to return which category it comes from. Each category has multiple unique states. Ex. I search for CA within whole time, I want it to return me the...

Hi, I am trying to reference different sheets in a formula which are named: CATEGORY HIERARCHY (1) CATEGORY HIERARCHY (2) CATEGORY HIERARCHY (3) The (X) value I have in cell AG537 but for some reason the following formula is not working. I have entered the correct sheet name and the formula...

Hello, This is my first post so I apologize ahead of time. I was wondering if there is a formula that will calculate the next occurrence of a date based on different time lengths? I have found many solutions dealing with whole month intervals and weekly/biweekly intervals separately, but for...

Hi everyone. Semi-lurker and I can find my way around a spreadsheet but not much of a programmer. That said, I've offered to try and write a spreadsheet that will count and determine the winner of the local Quilt Show this summer. I can make it work with a big enough hammer and an IF...

I have a data base with dates in column C, Category in column G, and Amounts in column R. On a sheet2 I have the start date in B2 and end date in B3 and in Column A I have the category names. In column B, I want to get the totals from column G (sheet 1) for rows within the date range and match...

I have set this up numerous times by searching for Dependent Drop-down list and following the instructions. This works well when using only two cells, one for the category, and one for the items in the category. I'm having a hard time translating that when I want the category in column D and...

Hi there, I have a Spreadsheet which has some categories within it, for simplistic sake i have category AA and category BB. What i am wanting to do is to display all values vertically which match category AA and category BB from within a table. For some reason, the first iferror works...