category

My Task is to Summarize the Ingredients By Categories. I have two Worksheets/Tables. The First lists the Categories and their respective Recipes CategoryRecipe <tbody> Category (A) Recipe (B) Cat1 RecA Cat1 RecB Cat2 RecD Cat2 RecC Cat3 RecA Cat3 RecD </tbody> Next is the...

I have a large amount of data with columns for Division, Department, and Account. I want to assign a category to every row of data based on complex criteria in those columns. Here are some examples: Category is "Absorption" if Division is not 000, Department is either 000 or in the range of...

Working out time. How do I use a column to calculate only if a cell contains specific criteria? e.g. Only calculate difference between start and end time if the category is "Accrued" otherwise use "0" <colgroup><col width="80" span="5" style="width:48pt"> </colgroup><tbody> Category...

Hi everyone and thanks for reading this message I hope it makes sense. I have this exercise I found on the internet in which i need to return the price of the breakfast in a chart depending on the room type and Hotel Category. Basically I need to multiply the "Breakfast price" with the...

Hello, Can someone please help to suggest how to do dynamic multiple sorting with criteria in VBA? I have a data table with header title : LOCATION, ITEM#, CATEGORY in different columns that i would like to sort the table in the following column sequence. 1st sort : LOCATION 2nd sort...

Hi All, I have a worksheet that extract all data from another data base, I need only certain filtered category data to be updated, but when click on the "Refresh all" button, data with all category have been down loaded every time, how and where can I set only update the filtered category data...

I've been banging my head against the wall over what I think should be a pretty straightforward formula. I have a year's worth of expenses that I've categorized with 10 business categories. To start, I used a simple SUMIF to sum any expense in a range for each of the categories to get the...

Hi all, I am struggling a little to make a COUNTIFS or SUMIFS formula work on my spreadsheet. I am trying to count the amount of errors made depending on the category. I have the scores in one tab and the table containing the number of errors in another. So.... My current formula is below...

Hi I've got a dashboard with doughnut charts - lots of 'em and I need to be able to CF them based on the category NOT values. I am completely stuck. I have followed this: https://peltiertech.com/vba-conditional-formatting-of-charts-by-category-label/ and filled the cells with the colours I...

Hi guys I've read a few posts on how to sum values across multiple sheets meeting a lookup criteria. None of the threads I've encountered have explained it this noob. I've tried the ExcelJeanie without luck, the version is incompatible with the Excel I am using. The data below is comma...

Hi guys I've read a few posts on how to sum values across multiple sheets meeting a lookup criteria. None of the threads I've encountered have explained it this noob. I've tried the ExcelJeanie without luck, the version is incompatible with the Excel I am using. The data below is tab delimited...

I am a VBA beginner and I need your help to solve a problem that I will explain in detail below. Suppose I have a table like this in an Excel sheet called “Merged” contained in “Foglio1.xlsx” Workbook. This table was obtained by merging together four different bank statements of two different...

Hi Team, I am looking for some help here, I have base data and need to get the unique info based on one criteria in the below example is is "Category". Why I am looking formula is because it should dynamic and should not perform pivot/remove duplicate every time. Base Data...

Hey guys - I have a bit of a complex question but I am trying to do some sorting / formatting with VBA and write a macro to help me sort through some large volumes of data. The dShouldata is stored in a table similar to what is shown below. A few key notes about the data: The Data Column A...

Hi Community - I'm hoping you can help: I have two Columns: On a data sheet titled 'DataSheet' i have the following: Column A: Contains a list of product categories Column B: Contains a list of sub-categories for each category On my active Sheet titled 'BusinessSheet' I want to be able to...

What code can i put into the two cells highlighted in yellow to sum up the WDRAW column by category? See attached image. I'M TRYING TO FIGURE OUT WHERE MY MONEY IS GOING!

I am trying to create a formula that shows team members that are on PTO for the current week. Each day of the year is listed in tab “Data” in column A and the names are listed for who is covering Category A, Category B, Category C in columns B through D and PTO1, PTO2, PTO3, PTO4 are columns E...

Hi, I'm trying to show total expenses for each person, in a separate category, from a pivot table, as follows: So each bar represents the total spent, while each color represents the category it was spent on. I'm having trouble getting Excel to do this, as it just creates a new bar for each...

Hi I have two tables, first states part number, category and price. The second table states part number, category and price. I enter part number and category in table one and need the lookup to populate the price from table two depending on the part and category? I have done a vlookup and can...

I'm trying to do a concatenate formula to combine all the categories from sheet 1 into one cell. The values in Sheet1 for categories would be a drop down list of blank, L, M, and H. In Sheet 2, if the category has a value, include it in part of the concatenate formula. Is an loaded IF statement...