category

The first column is for the ITEM TITLES of random items and the third and fourth columns are for the CATEGORY ID and CATEGORY NAMES, respectively, that the item could fit into. The second column, ITEM ID, needs to associate a CATEGORY ID to each item by matching a word in the title to a word in...

I would like to return a demographics category's maximum (lowest) dimension in text form. I'm able to determine the maximum value of the dimension, but I can't figure out how to return its text. Please see sample below. The maximum dimension for the birth year demographics category is fairness...

Hi everyone, I've got a problem that is very straight forward that is beyond my abilities. It is as follows: I have a sheet that tracks all expenses and info regarding them (Date of expense, check number, expense item, dollar amount), where all info regarding a particular expense is stored side...

This is a little tricky to explain. I want to make multiple sums within the same group when the value is maximum 500-800 (need to decide upon this). From row 7 to 28 I have the product category B1-2-2. In column E, i'm illustrating what I am working on. When summing D7:D14 I get 595. I then...

We are redoing the category structure of our website. Some products live in multiple categories, so the field will contain 2 or more category IDs like 1234,5678 or 90,123,4567. I have a lookup table of what the new values should be, but some of the categories are also going away. Sample Data...

Hi, I would like to be able to pick a folder and then the macro/script goes through the main folder + subfolders and then also e-mails within to check their category and then post a result on how many mails were put on the different categories. I have found two different scripts that each...

Hello i am having some trouble with this below question and i am not sure how to solve it. Beings i cannot attach the document it might be confusing. Let me know if you need any other information to solve this. Thanks in advace! On the InventoryAudit worksheet, the cells in range A3:D17 need to...

Here is the Sample that I will be referencing: https://www.dropbox.com/s/qsnzojulgipugma/Test.xlsm?dl=0 In this financial planner, I have data in sheet one that gets moved over to sheet 2. When this happens, it auto updates the text to remove all the repeating data. (card number). I have made...

Hello, I’ve been asked to create an employee performance review spreadsheet with drop down lists, each employee will receive a percentage of their pay as a bonus. Every employee is in one of three incentive categories (let’s say these are called high, medium and low) and for each rating (let’s...

So I admit Im not great with pivot tables so this is probably something simple I have a large Ledger off all checks written this year Date Written to What For Category Amount when i turn the data into a pivot table the category "training" shows up twice everything...

I have Column B Conditional Formatted based on Column A's data. <tbody> CATEGORY 1 100 CATEGORY 2 200 CATEGORY 1 150 </tbody> <tbody> CAT 1 TOTAL: </tbody> When I pick a category from a Drop List in A, I have B set to change to a certain color. I...

hi there, how can i make certain words fall automatically under a category. for example i have spoon, fork, knife, plate, bowl, saucer, i want the first 3 to always specify cutlery in their next column and the last 3 to always specify dishes in their next column any time they are typed the next...

Hi guys I need help to write a code to take emails per category from inbox with counting .. For example i have categories called "ARBOR", "NAGIOS" and i want to put emails received from this inbox folder with subject and count and date

Hi all (picture attached to explain this). I have an excel form that we're using for training and compliance inspections. It has 5 sections, each with a unique category. The main section is for my "Observations", and I used VBA and a button to add rows beneath it for "action items" - things I...

Hi, Have a table with Date, Category, Source and Rate, need value returned from Rate column, inputs are date, category type and source and each Date&Category&Source is unique (want to avoid using a helper column and VLOOKUP) If inputs are: Date: 30/06/2018 Source: Data1 Category: Number I...

Hi all, I am trying to calculate the sum of a range where the row will meet the row will meet a 'category' criteria and the column will meet a 'range of months' criteria. The row criteria will be one 'category' but may be contained in many or none rows. The column criteria will be a range of...

<tbody> Specialty Category 25th median A spoon 1000 1500 A fork 2000 300 A knife 8000 1000 B spoon 5100 2000 B fork 6100 3000 B knife 7100 4000 </tbody> I am hoping someone can help with an array formula I am trying to write a formula in...

I have a "SUMIFS" formula that's returning a black cell. My formula: =IF(MONTH(G1)=MONTH(NOW()),SUMIF(C150:C150,"Rent",D150:D150),"") I'm wanting to create a formula that will sum up the values in D:D BUT only if they are in the "Food" category AND only if it's in the current month (G1) Can...

I want to remove duplicate serial numbers from column A but the 1 serial that will be kept should have network category from column of "NW*" Secondly I want to keep track of which serials will be removed so i will add another column and replace the removed serials with "To be removed" and the 1...

Hi all, I'm very new to using Power Pivot, so there's probably an easy solution to this, but for the life of me, I can't figure it out... My source data contains a list of employee IDs with the number of hours charged on various transaction dates. I have added a column to my source data that...