group

For instance, I have a whole range of job roles and the count, and I want to group several functions together, such as: Group 1 Sales Marketing Business BD Business Development Group 2 Admin Administrative Accounts how do I filter and group them together easily as long as the job role...

old thread: https://www.mrexcel.com/forum/excel-questions/1109413-use-table-column-headers-cell-reference-search-criteria.html Instead of using the column # in a cell/range reference I want to use the Table Column Header name. In workbook 1 the columns will continue to update over time, but...

I have a spreadsheet with 15 worksheets containing data for 21 cities. Some cities have multiple entries on their worksheet as they are separated by either north, south, etc... or uptown, downtown, etc... New York - Bronx New York - Queens New York - Brooklyn New York - Staten Island as an...

I have two worksheets with chart data. There are two groups in worksheet 1 : A and B, each group has 3 subgroups "X", "Y" and "Z". Now there are few numbers in the left column and values are plotted against the each of the numbers in respect to the group and subgroup. Now, there is another set...

Hi Excel gurus, Could someone please help me. I have a report with users group assignment in the system. Users are assigned to read-only and full access groups. Email address is the unique field in the report. I wanted to apply a formula under User ID's so we we can identify and filter if...

Hello guys, My data set is like this: <tbody> Stock Return Criteria1 Criteria2 Percentrank.INC 1 0.1 W 0.9 2 0.3 M 0.7 3 0.2 NA 0.3 4 0.1 L 0.5 5 0.5 M 0.33 6 0.2 W 0.88 7 0.1 W NA 8 0.4 L 0.2 9 0.2 L 0.77 </tbody> What I want to do is to run double sorts in VBA...

In column CB I have list of items then CE has their respective values. Now the items in CB are grouped into four - meaning each group has same value. So I need a way to display with a message box - VBA: Group 1 = Value 1 Group 2 = Value 2 Group 3 = Value 3 Group 4 = Value 4 I have been...

Hello, I need to run a report for work to show me revenue and qty sold in each categories, and sub-categories. Unfortunately my ERP system doesn't break the category down so I have had to do it manually in Excel, this is how it's shown on our system - "Catheters > Gloves > Powder Free...

Hello guys, I have 2 columns, the first one (we say A1:A100) contains 'W's, 'M's, 'L's, and some 'NA's, the second column (B1:B100) contains figures (stock returns) and also some 'NA's. what I want to do is to calculate the percent rank for each stock under 'W' group, 'M' group, and 'L' group...

I need to color code a group of cells every time a value changes. For example, in column A, I have the word Truck in the first 5 cells, then the word Horse in the next 5 cells, then the word Plane in the next 8 cells, etc. I need a formula to color cod each group of cells whenever the value...

Hi, I want to create a drop down where they select a group and all the names fill in below it. GROUP 2 JOHN LARRY LUCY GINA FRANK ANNA Cell A5 is my drop down where they will select the group Starting in A7, I'd like a formula that would look at A5 and start to list the names. Essentially...

Hi, I've been reading other posts here similar to my issue but I can't seem to get some of the workarounds or methods used to work. We had an intern working with us over the summer and he created a bunch of different reports in Power BI, I still have access to his account but my company needs...

I have a fairly large spreadsheet to list customer details which is sorted by sales reps (about 40 reps). I want to be able to double click on a rep's name (in Column C) and have VBA automatically group the rows below it that have the same data in column C as what was in the cell that i double...

I am trying to sum rows based on some criteria. (The Group column is only here to explain that the rows come in "3s"). This is the data: <colgroup><col span="5"></colgroup><tbody> Group Field1 Field2 Field3 Field4 1 a aa aaa 1 1 a w aaa 2 1 a aa aaa 3 2 d dd ddd 5 2...

In the table below, I need to get a unique list of IDs with a count of how many were sold In the example below, ID #1 was sold twice, #2 zero, #3 one, #4 zero, #5 one. In order to do this, I have to group it by ID and aggregate with count But doing so results in 2 for #1 , 1 for #2...

Hi all, I have a workbook that's combining time off calendars for a couple departments with hyperlinks to hidden worksheets (months) for each department. This is what I have written on the Navigation tab Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo =...

Hey, together I'm currently facing a small challenge again.I have the following two tables. TblActuals <tbody> Product ID Group Quantity (Actual) Date A1 A 100 01.01.2019 A2 A 150 02.01.2019 B1 B 50 15.01.2019 B2 B 150 16.01.2019 C1 C 25 08.08.2019 </tbody> TblBudget <tbody>...

Hi im trying to find out how to count the numbers in each group, using macro instead of formula, the group go on for as many as needed, i want it so that it does number part for me...once i have filed out group and name... <tbody> Group Name Number G1 ASJ 2 ATT G2 AMM 4 MKK...

I've tried really hard to find an answer to this problem but cannot find it. Basically I have an table which is populated as below: <colgroup><col><col span="5"></colgroup><tbody> Band 1 Band 2 Band 3 Band 4 Band 5 Product Group A 10 25 40 55 60 Product Group B 15 20 25 35 40 Product...

Hi, I am kinda new to excel and I have this pivot table that has 2 filter values. I need the rows to show both filter value but it should be grouped by value or at least if I could sort them depending on their filter and add a blank row in between so I could label which is which depending from...