categories

I'm very new to vba so bare with me :). I have column A that has all existing categories, new categories are listed in column C. I'm trying to determine how to take these new categories, and add them to column "a" if they aren't already in column A. In the example the new categories in column C...

I need to know if/how I can take a generated array and store it for later use. The application I'm building is specific to my industry so please be patient as I try to explain what I'm doing and what I would like to do. I am building a template that will be used as a stand-alone for individual...

Hi, Can anyone tell me if it's possible to create new categories for slicers in pivot charts/tables? Essentially I want to be able to make new categories of slicers based on the data already in my table (for example, if I have data in columns 1-10, I want to make a slicer that will group the...

I am hoping somebody can help me here, my Raw Data is from a support org and has the Client service Manager, client names, Categories of work and hours worked in the raw data. What I need to do is create a pivot table that will look something like this <tbody> Category A Category B Category...

Context: I'm creating a database of resources for my team to use. The goal of the database is to allow people to sort the resources across multiple dimensions: topic, specificity, which projects they're related to, etc. All the data is text - there are no numbers. Problem: Many resources belong...

Hello All, I have 2 worksheets named Year 1 and Year 2 with categories. What would be the VBA to compare column A (categories) in sheet Year 1 & Year 2, enter value of column B/Year 1 in column B/Year 2 if matched, and highlight Year 2/Column A categories that are not in Year 1? Thanks!

in Column A I have several categories. Chefs Features Entree2-Mindful Accompaniments STG/LTO (just to name a few) Are a few of these categories. After EACH category, there are 4 items (all in Column A) Is there a formula to extract all the data in the cells beneath each category? For this...

Hello All I'm looking for a formula to calculate the below scenario. company for example has 7 sku divided to 2 categories smart and none smart, person has target of the 2 categories and when the person achieve 100% of his target i need to calculate his commission based in different price per...

hi everybody! i am having some trouble in using pivot table after a few years break so so if anybody might guide me what am i forgetting i am working in garment cutting and for every new order i have to maintain a record of the measurements 1: cad pattern 2: first garment 3: first garment...

The following scenario was already addressed on another post: In the following table I would like the code to return “Fruits” if the cell contains a word that refers to a fruit (i.e. apples, oranges, pears) <tbody> I love apples Fruits I like oranges Fruits I bla bla lettuce Veggies I...

Alright guys, I feel a bit embarrased to ask help for conditional formating, but I have tried and tried to make this work out myself but I cant accomplish anything. I am just stuck. I need to do some multiple condition formating here. I have categories which take part of a material inventory...

Hello all. I am scratching my head over this. I am attaching a photo of my issues. I have data that I can figure out how to do a SUMIF based off the category (there are 7) but I want to be able to Change the date in my date cell P2 and have the sum for all 7 categories sum based off the date and...

I have downloaded by bank statement into excel and want to add categories to each line. The statement download provides information in column D sheet 1 similar to CARD PAYMENT TO TESCO-STORES-6352,4.32 GBP, RATE 1.00/GBP ON 13-11-2015 CARD PAYMENT TO CARPHONE WAREHOUSE, XXXX GBP, RATE 1.00/GBP...

Hi, Given a large number of books to label and sort in a small library. Authors and titles are in an Excel2010 workbook under win7 OS. Strings are grouped in alphabetical categories (Ygroup table). Using VLOOKUP function, the authors are assigned id#s as per the Ygroup table categories. For...

Hi I have spent SO much time in Excel trying to get this to work but have failed miserably, when I think I'm there, I test it and it fails.... This is the scenario: We pay staff weekly based on 4 different categories of shift as follows (all paid at different hourly rates) which they submit a...

Hi everyone, I could do with some help. I'm working on a project where I need to take selected data from worksheet 1 and then break it down into different sub categories in worksheet 2. <tbody> <tbody> The above is worksheet 1. I need to take the higlighted info from this worksheet and...

Hi there, I have a document where students scores are inputted in column N:AJ with the column headers as the categories. I am wanting in columns C:E to pick out the 3 lowest scores and their corresponding categories. I have used the following formula...

Hi there, I am looking on the internet for slicers with sub categories, check even the pivot tables slicers but it sound I can't understand. I need a first slicer with 5 products and than I need below each product another slicer with the sub names. Smth like below: So I need the 1 slice...

Hi, I have an excel doc I want to send to a freelancer to upload onto our website, but can't figure out the specific formula to edit this messy category from Sheet1 into the same categories, Sub Cats, and sub-sub cats in Sheet2. I have about 30 of these all with different formatting but still...

Hey Guys, We have been using Excel for at least a decade now and would not consider ourselves to be beginners buttttt we have come across something that has had us stumped for a few days and were hoping to reach out to the true experts for advice. Basically, we need to create a simple Pivot...