category

Hi I think this may be an Index/Match formula but not 100% Trying to work out a cost based on two factors as displayed below. <tbody> Hardware Category Berlin Amsterdam London Frankfurt Copenhagen Lisbon Madrid Barcelona 1 £175 £175 £35 £175 £135 £235 £235 £235 2 £185...

Hello, I want to pull names connected to a category. I need help pulling all names associated with this category. The name column also grows throughout the year. Is there a formula to use that will pull all names associated to the column? OR Can I make a pivot table and then extract the names...

Hello everyone, Not sure if this is possible, but I think to think "All Things are Possible", so I figured I would ask. I have some data where the first column is category then every column after that is id's for that category. <tbody> A B C D 1 Cat 1 1000 1200 1450 2 Cat 2 1002 1305...

Hello, I'm trying to assign numerical values to a set of particular strings; and then add the numbers. It would work something like this -- Category A = 0 Category B = 1 Category C = 2 Category D = 3 -- with "Category A", "Category B" &c. in a dropdown list. Then, a cell with this formula...

Hi, I am wondering if there is anyway to calculate the Product for column "value" based on category with just using excel formula? For example, based on the table below. I want to find the product for category A = 1*2, category B = 3*2*2 and C = 3*1*2. I tried using SUMPRODUCT but instead...

I'm building a calendar format spending tracker. I'd like to keep track of daily, weekly and monthly costs; and then also track costs by category (see image below). The tracking by category is what has the SUMIF function not working. I've been trying to select specific cells to look to, but I'm...

Good Morning, I was hoping someone might be able to help me out with the following question: I have built a spreadsheet that generates data on a monthly basis for 100 distinct "blocks" (January through December, vertically oriented, 100 times; the example below features only 2 months for 1 of...

Hi, I have a query related to SUMPRODUCT with multiple criteria in Rows and Columns. Using the below example to explain the problem. I have data of sales figures of various products belonging to different categories for different quarters over a few years. Am trying to calculate the...

Hi I am trying to create a dashboard that gives me the top 5 (and bottom 5) on a number of key metrics. I have put an example table below, but I trying to create a result that will list in order 1-5. Please assume Category is column A, Product is Column B, etc...

I have two columns Column A and Column B Column A has all existing product codes Column B has all existing and new product categories Old Product codes consists of two parts two letters and a 6-digit number the letters always remain the same ER the numbers were picked at random. So existing...

Hello guys, Please find attached an EXCEL I created for Daily Expenses / Outputs and Daily Sales/Inputs. (cant find attachment feature here) Unfortunately I can't use the FILTER properly. -If you try to filter BANK category to show only, it also includes Cash. -If you filter CASH category to...

I have a spreadsheet with 200k+ books/descriptions/etc, and I'm looking for a way to search in each full row (A-x) for keywords (sheet2, column a, not case-sensitive) within the text, and when it finds those keywords, it assigns a unique category ID (sheet2 column b) to each row for each match...

Hey all, thanks for looking at my question. What I'm trying to do is create a VB program for my budget. In my budget, I have two areas for data. One area shows a running total of my current allowance & expenses for any category, and the other area is where I enter each individual expense...

Hi - I have 2 columns with 200 rows. Column A in cells numbers - column B in cells text being categories I require a formula to look at all cells and add up for each category There’s about 15 categories in the cells with repeats So example A. B 1. 50. Red 2. 20. Green...

Thanks in advance for any suggestions for which I will give feedback. Anybody know why it's ignoring my data or what part of my code is incorrect? The following code causes the remainder of the code not to execute after it finds Category A. Once it finds the first category that exists, whether...

Hello all! This is my first post but I've been following this forum a solid 2-4 months in my journeys learning Excel and building dashboards. The resources present on this website have been of immense assistance. I've ran into quite a roadblock on my current project and was wondering if you...

Hi, I am struggling to display data in a visual way. I am trying to show a customers market growth across several categories and then my companies growth in those categories relative to the market growth. As an example: In Category 1, Customer A had growth of 2% in the market but our business...

Hello I am using the following: =MID(B5,SEARCH("[",B5)+1,SEARCH("]",B5)-SEARCH("[",B5)-1)+0 Where cell B5 has the following contents: =IF(B6="","rdhgxfjhsftjhjh(Text to extract)hujkfjkdjsdt","") and cell B6 is blank. I am receiving a #Value error, and am unsure why. My cells are formatted...

Thanks in advance for any suggestions and I will post feedback! The code should do copy and Paste Transpose seven times, but it only does it once. Any idea why? Seems like it's not running the Loop and the issue must be with If Then Statements. The only part of my code that seems to get...

Hi all, Would greatly appreciate some guidance on the below IF statements. I do not have an error values but the values that it generates is incorrect. Column A: Category 1 Category 2 Category 3 No Data Entered (I wanted to put this in for a blank....but perhaps I should just leave it blank)...