1. N

    Split and group values in excel

    Hi I have a column of values which has different suffix after a dot, i need it to group it based on the value after dot. Example i need to split all values that end with .pdf into one column, values with.xls as another column, etc,,, how to do this is my doubt.
  2. E

    How to copy data from pivot with saving of groups and structure

    I often have to copy data from pivot tables in order to make sales reports later. In the pivot table, my data is structured according to the following hierarchy: Brand name-season-category How can I copy the data from the pivot table so that the data is like in a regular table, but the...
  3. T

    Power Query: Group by - Output Multiple Sum Columns

    Hello all, I'm currently working on a query that will eventually feed into a chart. The original table was too large and exceeded the chart's maximum 255 data series so I wanted to rewrite the query to group the rows by multiple columns with constant names. The issue is that the header names of...
  4. Jaafar Tribak

    Grouping UserForms [Having userforms follow each other when moved around the screen]

    Hi, This is a vba code that hopefully accomplishes what the title of the thread says. Obviously, the forms must be modeless so that the user can freely move from one form to aanother. Problem is, using modeless forms makes this task difficult as we cannot subclass modeless forms to properly...
  5. W

    Cumulative sum Value by rank and per group

    Hi everyone, I have to put an evaluation to the certain data set (ex : image below), and I'm attempting to create a summary for the cumulative sum of value by rank per group. Column A is the number of data Column B is the Group of each data Column C is the value of each data Column D is the...
  6. J

    How to group or categorize data from one sheet to another when categories are unknown until data is pushed to output sheet

    Hello, I have a tool that spits out data to excel in a sheet with column headers and several rows of data. From that data, I'd like to transfer it to another sheet in a prettier format and grouped by a certain column based on the output. For example, I have a category column, for every repeated...
  7. E

    Pivot table Show products sold only in one year

    Hello, I can't post a screenshot with my pivot right now, but please consider a simple tabular pivot table with 2 columns. Column 1 contains years 2000-2020( group by date feature) and Column 2 has some product names sold in that year from column1. No agregation, only this 2 columns. (I'll...
  8. M

    Excel VBA Help

    Hello Everyone, I need some help with the data below. So, I'm trying to assign numbers to the Values in Column B. For example ,if Column B has Apple in it and I assign it 22, I want the next item on the list to be 23 and so on. Same items should have same value, as you can see in Column A. How...
  9. H

    Convert group of shapes to picture

    Hi, I'm working an a project where I try to convert a group of shapes to a picture and then delete the group. Shortly how I done so far: (the s_text, s_header etc. are programmatically generated shapes) Dim shpGroup As Shape Set shpGroup = sales_sheet.Shapes.Range(Array(s_text.Name...
  10. L

    Power Query - Append Grouped Rows based on specific columns AND row values

    Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost). Is it possible, via M code or otherwise, for me to group by...
  11. E

    Creating a new workbook with VBA including VBA

    Hi All, I am using at the moment a VBA code to create a new workbook. It´s financial data and therefore I want to use the group function to show detail in my totals. Next, i want to protect the two newly created sheets and save it as a new workbook. So everything works fine till this point, but...
  12. A

    Can you create "Sub Sheets" within a sheet in excel?

    For example, I have a workbook I use to enter data from my daily work deposits. Each sheet n the workbook has a single days worth of data. We run on a period schedule of 4 weeks. I would like to be able to create a sheet called "Period 1" and hide all of the date sheets within the specified...
  13. H

    Pivot Table (from Database): count total of grouped items

    Hi everyone, Is it possible to display the number of grouped items as a value or as a bracketed suffix to the name? For example: Accessoires would show "Accessoires (12)" and Accessoires Indoor would be "Accessoires Indoor (39)" even though it is collapsed. Alternatively, B3 would show the...
  14. H

    Group By SUM

    Hello, I have very simple data, that I want to group by SUM As the uploaded image shows. My Data has 3 columns, first comes Index, Numbers then Group, which I want to fill according to specific limit cell H2. I started by summing like cumulative column, then divided the result by the limit and...
  15. H

    How many sets of a number can I make?

    Hi! I have a huge set of data that includes hours employees have worked during a pay period. I need to know how many employees have worked 40 hours during the pay period. I can combine employees to get to one 40 hour employee. For example, if I have someone who has worked 40 hours they count as...
  16. J

    Hide / Show Group of Shapes / Textboxes based on Cell Value or Drop Down List

    Morning All, I have a workbook that I am working on and I have a load of shapes, textboxes and labels grouped together (Group 102) on a sheet (Income) and I would like to hide the group if a cell value or drop down is 1 or show it if it's 2. I have tried many various things that I have found...
  17. M

    Is there a way to create an "If Then" Group By in Power Query using parameter values?

    I am trying to create a Power Query with a parameter that what would perform the Table.Group function based on the parameter value. For example, if the parameter value Group by Region= "Yes", then sum up the sales and profits for each region. If the parameter value does not equal "Group by...
  18. G

    Systematically add 150 more rows every 51 cells down

    I have a sheet that has groups of 50 rows with a row to separate each group from the next. I would like to increase the amount of rows in each group by 150 (a total of 200). So starting on cell ("D55") add 150 rows above D55:AA55, then go down 51 rows and repeat for cell ("D106") [add 150 rows...
  19. B

    Conditional change: Change value in a cell based on specific text (ending in "X") in another column

    Hello Board, I am new to board and dumb, hoping someone would share a simple VBA code I have a large table of data of ~10000 rows. I'd like VBA Code to loop through: 1) evaluate data in column A for cells that contains 5 characters ending in letter "X" 2) If it finds such, I'd...
  20. C

    Grouping Rows

    Hi all, I want to group rows in blocks of 2 rows at a time. For example...row 1 & 2 would be a group. row 3 & 4 would be a group. so on and so forth. I want to use the 1 & 2 button to open and collapse the groups. I had it before but can't for the life of me remember how to do it again. I have...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back