groups

Hello, I have a column with over 600 ID's in it. I need to separate this column by groups of 25. For example, the first 25 people are group 1, then the next 25 people are group 2. I would like these groups to be in different workbooks, but I would appreciate any help to even just label them in...

Is there a way in a new column to group people in groups of 9? The first 9 people would be in group 1, next 9 people would be in group 2, etc? <tbody> Person 1 1 Person 2 1 Person 3 1 Person 4 1 Person 5 1 Person 6 1 Person 7 1 Person 8 1 Person 9 1 Person 10 2...

I have a pivot table of Names in the ROWS section and Groups in the COLUMNS section with the VALUES counting the number of Names. In my groups there are 3 categories, A, B, or C. Let assume I have 10 names but only 8 of them are in Group A. If I filter for just Group A, it shows me the 8 names...

Hello Excel superior beings, I bow to your wisdom and knowledge. Apologies for reposting this question, the last post had such poor layout! I think I've fixed it now and you can see the tables below. I know this must be possible but I cannot think of how to do it and have used this forum in...

Hello Excel superior beings, I bow to your wisdom and knowledge. I know this must be possible but I cannot think of how to do it and have used this forum in the past to find information but cannot think of how to even look for the answer. I have a list of groups with group ids and members of...

I want to shade groups of 5 rows. Basically shade 5 rows, 5 rows not shaded.. I have experience doing every other row, but not grouping 5 rows at a time. Thanks or any help. Nick

<tbody> A B C D Active Groups # Group # Region 000002 007895 West 008975 000002 West </tbody> Hello, I can't seem to find a workable vba solution for this problem:I want to count the number of active groups per region. i.e, West Active Group Count =1 (Group00002 is the...

Hi I am a bit stuck with this and i need a bit of help I have a list of products that needs to be divided into equal groups by Weight and Order value. I cannot add the img tag so i just leave the link below: https://ibb.co/XLWk4Yb Thank you

Hi, I have a budget template that has IF statements to exclude costs bases on the max allowed ($25,000) and the previous years' totals. I have 4 groups of these per year for 6 years and all the IF statements appear to be set up the same and work in all but one of the groups and I can't figure...

I have the table below and I need to write a VBA script to change table 1 so that the data looks like table B and pastes the data in a new tab in the same workbook The only distinguishing features between the rows is that one is bold and the others are not. The Bold is the overall group and the...

Is it possible to create custom bands in a table? For example, I have a few hundred rows of content and the first column is an identifier that looks like this: ClientA-48102-1 ClientB-51556-1 ClientB-51556-2 ClientB-51556-3 ClientB-59900-1 ClientB-59900-2 ClientC-40938-1 ClientC-40938-2...

To set the scene: I have 800 or so products, each with a unique identifier. These products have associated notes on a system, each with a varying number of notes. These notes are managed on an Excel document. Therefore, on a spreadsheet, I have groups of products. Some are in groups of 2, some...

Hi, kindly help me. In column A , I have a list of User while in column B I have a list of groups. Some user belongs to multiple group. What I want to happen is if I select a user all of the groups it belongs will be display. Any suggestion?TIA.

I have a table with data sorted into rows for review, rows that are ok and rows that are other, between each data set is a blank row. I want to run a macro that: extracts the data for a person(I've got this), groups the data by review/OK/other , closing(hiding) 'Ok' and 'other' groupings...

Thank you in advance for your help. I have a list of items some of which have 0 values. They are separated in groups and I would like to output the list keeping the groups, but deleting the rows with 0 values and adding a grand total: <tbody> <tbody> INPUT Item Unit Price Quantity Total...

Hi, I have different groups in my ribbon. I organise them one after another using </group> <group id="GPNOutlook" insertAfterMso="GroupEditingExcel"> <button id="BtOutlook" but is there a way to get this last group placed completely to the right of...

I need to count the occurrences of groups of symbols in a column as follows: <tbody> Symbols X O O X X X O X O X X X X O X X X X X O Groups Occurrences O 1 2 0 1 OO 0 0 1 0 OOO 0 0 0 0 OOOO 0 0 0 0 X 0 1 0 0 XX 2 1 0 0 XXX 0 0 1 0 XXXX 0 0 0 1 </tbody>...

I have search the forum and found coding on how to delete subtotal groups that equal 0 and have tried a few with no success. I must be missing something. My subtotals are added for each change in column F and it is subtotalling amounts in Column M. I haveover 460K lines of data.I started...

Hello, I made a stupid formula. It works but as my data increases it gets impossible. I need a better version of it. No VBA plz...

OK, I have a list of numbers, all of which are random. I am trying to create a non-repeating list of numbers in grouips of 6. I am trying to do this using VBA if possible. Number list 3 6 10 13 14 16 17 18 23 25 26 27 29 30 31 32 34 38 The ideal output for me would be: 3, 6, 10, 13, 14, 16...