categories

Hi I’m a really stuck, I have a category list in EXCEL. I have a 35 categories, each with sub categories and each sub categories has further sub categories, a total of 6 levels. The amount of data I have to input manually is in about 15164 lines, over 6 columns. Level 1 = 35 Level 2 =...

Hey everyone, I have a worksheet where the information is displayed in the following manner: a table containing 3 columns: A - List of objects B - Categories C - Comments I have a userform in VBA that is built in the following manner: 4 checkboxes (corresponding to the categories in column...

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 I have a list of names in a column A and a list of categories Cols B-F Each person can be tagged to several categories with the value of either 0 1 2 3 or 4 I am after a way to create a separate summary sheet that will tell me the person’s name in one cell (which I can do with...

Hi All, So I'm usually posting on here about my Excel exploits, so something a little different today as I'm coming back to Power BI after a couple of years away. I'm building a Sankey Chart which has 4 steps to visualise flow - there should be no difference in the start and end figures. I'm...

i have a financial tracking sheet i developed that works fairly well for me. but have run into a wall on it when someone asked me to make a change. so here's what i have: on a quarterly basis, spending amounts and their categories from each week are entered on separate sheets, and there is a...

I am having some trouble using sum with Index, Match, Match. My Formula is =SUM(INDEX(Sheet1!$B$1:$R$50,MATCH('July 2018'!$B10,Sheet1!$B$1:$B$50,0),MATCH('July 2018'!$O$2,Sheet1!$B$1:$R$1,0))) I need to cross match two categories and where that information meets up, I need to sum. Thanks

Hi, I have a budgeting app that is missing a feature, so I need to perform this calculation manually. I would like to have excel do it for me if possible. Is there a way to distribute a remainder proportionally across the separate categories? In the sample below I need to divide 1.26 among the...

Hey all, so let’s say I have a pivot table that has many categories. I want to tell the vba to onlygrab the categories in colomn A and not the blank cells and paste them in tab “sheets” in colomn s. How would i do that? Thank you in advance !

Hi everyone I am in a bit of a pickle with some data i need to analyse. I have run an employee experience survey and have a spreadsheet with the info. Now i am trying to figure out how to analyse one part and i think i need extra brains! So i have 11 factors that make up our employee...

I have two sheets: the first with data with column headers as 'Line#s' I need to change based off of a lookup table on the second sheet. Both tables have an overall category (ID) and sub-category (Type). The header names in the lookup table vary depending both categories. I need a condition...

How can I get the first word from these examples? <colgroup><col width="314" style="width: 313.33px;"> </colgroup><tbody> Sprint MINI CATEGORIES Sprint_to_Fastest MINI CATEGORIES Sprint_to_Lowest MINI CATEGORIES Sprint_to_Day_Morning MINI CATEGORIES...

Hello, I'm trying to build a macro that will sum the values from Column E based on multiple categories in Column D. Column D is comprised of various job functions (e.g. RECEIVE PALLET, CUTTER, and LETDOWN REACH) and Column E is comprised of the quantity completed for those job functions. In...

Hi I have got a long excel sheet with many categories. For example, A B C 1 Name Category Amount 2 T1 X 1000 3 T1 Z 1000 4 T1 Y 1000 5 T2 X 100 6 T2 Z 100 7 T2 Y...

I've spent hours researching this question with no results and the Excel object model posted in MSDN has not been any help. I have an Excel spreadsheet with a prebuilt pie chart that is opened by Access and manipulated via VBA. The data to be displayed is populated and the resulting chart is...

I have description in Col A. I need a sumif formula or another formula to sum the data where I have summarised the descriptions into categories See sample data below It would be appreciated if someone could assist me Book1AB1COS Shirts Used15952COS Tracking Used25843O/all PRF...

Hi Forum I need some help develop a formula for "filter" multiple text in just one result I have a table of products with multiple categories assigned in same cell Example Structure <tbody> ID Product Category 1 Product 1 Cat1, Cat2, Cat3 2 Product 2 Cat2, Cat3, Cat4 </tbody>...

Hello all, For example I have an mail box: name: TestingEML @ name: testing.eml@test.com The macro works like this: 1. Run Macro 2. Box with all email boxes pops up 3. Select the folder you need to extract emails from manually 4. The macro extracts all emails from the selected folder into...

I have categories in Col A and a corresponding rating in Col B. Col A is dynamic. Col B is fixed to:Avg,good,new, or null. Not all categories will have ratings (null). I am trying to group the categories by ratings - with specific formatting. See below. Desired result is in B10...

Hello, I have a Pivot table which has "Week starting" date as rows, "categories" as columns and "sum of sales figures" on that day of that week under that category as Pivot summary. Can I have a hardcoded/constant row on the top just below the categories with "Expected Sales for each...