categories

Hi All, I'm using Excel for Mac, and am working on my budget. I've created a pivot chart with a slicer for my monthly categories, but would like for the categories with no values for the month selected to be removed from the slicer. I've googled a good bit, and tried unchecking "Hide Items with...

I have a list of prices, products, customers, etc. that are in categories (Beef, Chicken, etc.) and in subsets (Salisbury, Ground, Raw, etc.). I am using the Aggregate function to determine the lowest price. Then, I use the VLOOKUP function to search that lowest price for who is purchasing...

Hello! I am trying to do an INDEX formula to find specific dates. Everything was working fine until I realized that I have 2 categories that have the similar name. The 2 categories are "End User" and "End User Exception". I just want to find the "End User" and not have the "End User...

Hi All, Could someone please help me with the query below I have 3 sheets Labels, Labels and Categories and Results. I have to check the all the values in Labels sheet against Labels and Categories sheet and report the total numbers in Result sheet. Please see example below. Thanks in...

Hello, I need to run a report for work to show me revenue and qty sold in each categories, and sub-categories. Unfortunately my ERP system doesn't break the category down so I have had to do it manually in Excel, this is how it's shown on our system - "Catheters > Gloves > Powder Free...

I'm currently working with a dataset which has one dimension(column) with categories a,b,c,d,e, and one dimension(column) with categories 1,2,3,4. I've exported subset 4 and made manual categorization of it, let's call them !,?,#,@. Then i made a pivot table of the subset with categories...

Hello, i was looking for help on an excel doc, its basically allocating the expenses into different categories but the names for the expenses differ, is there any way i can make the names fit into these specific categories or change each name to fit the category? https://ibb.co/rxw47zq EDIT...

Hi All, I am tracking movement of members between categories, "Affiliate", "Fellow" etc. Members can move both ways between these categories, e.g. from Affiliate to Fellow, and from Fellow to Affiliate. (Note, if that sounds odd, its just an illustration). Does anyone have any ideas on how I...

Hi there! So I hope I can explain what i'm trying to do clearly. I have an input table where users input hours for a labor category (column) and a task (row). The user also has the ability to insert more categories (columns) and more tasks (rows). In order for the information to become useful I...

Hi Guys I need some help with a PQ Merge issue i have to tables that i merge with the simple idea via a SKU it collects Categories from another table. All SKU's are present and the Cats are also listed. THis worked but when i add new items the Categories are not being picked up. I have added...

Hello All, I have 2 pivot tables based on the same range of data. There are reasons why these need to be separate for my use so they can not be combined. I am now introducing slicers to my worksheet. However, is there a way to make the position of my pivot tables dynamic based on the slicers...

Hi folks, 　 I have a long list (14,000 rows) of numbers (positive and negative) that I am trying to categorise into absolute value categories of 0 to 10, 11 to 20, 21 to 30 and so on ... So for example, 13 would return "11 to 20" and -4 would return "0 to 10". 　 These are my formula...

Hello, I'm working on my finances and have downloaded my statements for the past 12 months. I want to categorise my spending into various categories such as Car Expenses, Utilities, Loans and so on. What I am looking to do in Excel is after I have my statements imported I want to be able to...

By "non-time-aligned" I mean... I am getting data for say 2 columns of similar categories but there may not be data for both categories for the same time. Very hard to explain. <tbody> Time John Fred 10 am 3 5 10:09 am 9 11 am 6 2 11:23 am 7 1 pm 5 1:56 pm 2...

Hello People, I have 3 queries and would appreciate your assistance on them: 1) I have a specific concern which I've written in more detail after these 3 listed queries, on how to write a formula which will help group bulk of text data into the desired categories. 2) Could you recommend any...

Hello. I have a worksheet that I don't have control over that looks like: <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>#DAE7F5[/URL] "] A B C D E F G H I </thead><tbody> 4 #C6EFCE[/URL] , align: center"]Category 1 #C6EFCE[/URL] , align...

Hi there, it's been a while since had such a hard time figuring out what I need to do with certain formulas. My question is this. I have a sheet with days and the overtime that is worked on those days. The overtime is split up in 4 categories. OT, DT, PPH, PPH OT. Now the target for the...

Hi, I have a budget worksheet with multiple worksheets and multiple categories on each worksheet. I have arranged these categories in what I think is a logical manner however, I am a mortgage broker and need to submit these budget spreadsheets to different lenders. The issue is that each lender...

So, Essentially what I have is, a list of cars with their respective performance values for a game (Handling, Acceleration, Braking etc.) that I have then gotten a mean overall value for (Add them all up and divide by how many different values there are for each car). I am now looking to put...

Hi, I have sales data where they can be categorized in multiple categories. For example, on 10/1 I have 5 sales (notated by the last row) and they can fall under 6 categories. Here is sample data: Date . Name . Value 10/1 . Purses . 2 10/1 . Shirts . 3 10/1 . Watches...