group

Hello everyone, I'm trying whithout success to loop through worksheets hope you can help me I have a workbook with 40 worksheets of my employes The 40 worksheets of employes have those names 10 worksheets are for the first group : 22-01, 22-02 ... 22-10 10 worksheets are for the...

Hi All I have a long list of equipment to order. Each item fits into a procurement category (eg, bins or furniture) in column H and an installation group in column K (company that will purchase and install). Every item has a target install date in column J, and a number of items in column M...

Hi All, Could you kindly help me how to validate below data set in excel ? <tbody> ID Group_Name 112 Group 1 113 Group 2 114 Group 3 115 Group 2 </tbody> I would like to write a macro to validate that every group should only have one distinct ID In the above example Group 2 are...

I have been searching around the boards without any luck. I am trying to find an average of a series of values based on column headers F4:EU4 where the rows names in A5:A37 are unique. I have tried =averageifs(index($F$5:$EU$37,,match("Mutual Fund Name",$A5:$A37)),$F$4:$EU$4,"Peer Group...

I have created a custom tab on my ribbon through File > Options > Customize Ribbon and I have populated it most of the way with the Add button. I have added Solver and the Analysis Toolpak (Data Analysis button) addins to Excel and by default, Excel places them at the end of the Data tab on the...

This is hopefully a simple one. How can I count records based on criteria? So it would be a count of 'Active' ('Status' Field) for each 'Group'. I'm looking to go from something like this: <tbody> Group RecordID Status ABC 0001 Active ABC 0002 Closed ABC 0003 Active DEF 0004 Active...

Hi All, This is similar to a previous question I asked, but the table I needed to create for the other option was becoming way too large and cumbersome and the lookup number had to be in multiples of 1000. Here is my dilemma... I am creating a label quote system. There are 10 Groups of...

Hello, I need to count "grouped" cells with values as one. Column "I" has bunch of 1's and 0's if it was on or off. I already deleted all the 0's and was left with 1's and empty cells in between. For example: <tbody> 1 1 1 1 1 1 1 1 </tbody> This has 3 "groups" so the...

I am struggling to find a way to solve the problem below and wondered if anyone has any ideas on the best way to solve this. I have a number of people, lets say 40 to start with, attending a meeting where there are 4 groups of 10 people. The goal is for the 40 people in the room, each will...

Hi all, I'm creating a set of checkboxes for a multi-series chart so users can select which series to display. I'm trying to group them into a groupbox but the option is greyed out/disabled: I can create the Group Box via the Insert option on the Developer Tab I can create and format my...

I have the code to make a button visible or not based on their user group. But is there a way to say if user = "poweruser" show all buttons?

Hi, I have a list of dates in a pivot table; I amusing Excel 2016. I would like to present these dates grouped by month; however I cannot seem to do this? Apparently when I put dates into a Pivot on Excel 2016 it automatically groups them - it doesn't with these! Dates are formatted to be...

I have a table with some timestamps and some values. I need to group the data based on the time difference between datapoints - for example if the time difference between two points is greater than 3 days, put data in a new group. I have tried using a pivot table for this but can only group by...

Hi Everyone, I'm new to the whole VBA thing, and need to create a macro that will assign a group of merged cells as text (so you don't have to insert an apostrophe (') to mark it as text (content in the cell will likely commence with a dash (-)), auto-fit the row height of the merged cells, and...

Hi VBA champs..need help in designing "Macro to group rows and columns based upon each Row/column value in corresponding cell value for multiple sheets in workbook " 1. Each row should group independently for particular cell value say(0) in column "B" of same worksheet and ungroup for "1"...

I'm trying to get a sum by Month (from dates in row 1) and by group (in column A) using sumifs. but am stumped. suggestions? <tbody> A B C D E F 1 WEEKLY 10/05 10/12 10/19 10/26 11/02 2 Group1 91 12 33 64 29 3 Group2 3 6 8 1 0 4 Group3 12 69 3 4 56 5 6 7 MONTHLY...

Hi All, Based on another thread I had posted on Jun 1st, 2019, 08:04 AM I would like to create a macro for a variation of the original design I had created. A successful macro created and provided by member DanteAmor satisfied the original design requirements as per below: ____ORIGINAL...

Hi All, When we have the data ready for Power BI, does it have any in house function we can group the one column of the data? For instance, I have one data set and one column is the age from 17 to 99 so Does Power BI can group them somehow or customized so we have three age groups...

I have a pivot table in which the first column looks like this: 1 2 3 4 5 ... 50 If I group them in increments of 5, I get the following: 1-5 6-10 11-15 ... 46-50 I would like to group like this: 1-5 2-6 3-7 4-8 5-9 6-10 ... 46-50

Hi there, I hope this message finds you all well and in finc spirits today ;-) I'm trying to set up some macro buttons (ie a shape with a macro assigned to it) at the top of an Excel worksheet. This 'top' are ten rows which are 'Grouped' and typically collapsed when using the worksheet (i...