grouping

Strap in, this is gonna be long and possibly confusing. I have to test and record the first and last data point in groups of 25. Each quarter, the iterations change, so in Q1, I'm testing 1, 25, 26, 50, 51, 75, 76, 100. . . In Q2, I'm testing 2, 24, 27, 49, 52, 74, 77, 99. . . and so on...

Hi Everyone, I'm having a date grouping issue. I can group dates in my Pivot table by selecting all dates. As soon as I try doing it by selecting a single cell it says "Cannot Group Selection." I've reformatted the data multiple times and refreshed the Pivot table. Still no luck. Any advice...

Hello I am trying to group certain rows in excel. However for some reason, I can group certain rows and some rows I try to group it but only dot sign appears and not the + or the - sign appears. Please see the image for more information. Can anyone please help here?

I split a column by a space delimiter, after I have unpivoted the index column and try to group i get the following error: "DataFormat.Error: We couldn't convert to Number. Details: a" How do i fix this?

Hi all, I'm struggling to figure this one out...I've searched online and have tried suggestions for other similar requests, but to no avail... In my data set, I have Survey IDs (unique for each survey), but trying to add a column (Survey #) that indicates what survey # it is for that...

I have a table that has columns for tracking weather via METARs. METARs are messages that are used by aviation to pass weather readings. They are usually generated hourly, unless otherwise required, every day. I have a table that has 99K rows of data. Each day has between 22 - 28 rows of...

I have the below data and want to see how I can achieve the last column, in google sheets. I was given an excel solution in a different thread but unfortuunatelt the AGGREGATE function is non existent in google sheets. The excel solution given is: =IF(A2=A1,C1,SUBSTITUTE(B2&" TO...

Hi, Please see attached mini sheet. I am trying to transform a table via Power Query. The input data can be seen in the columns A to E and the desired output from Power Query are the same columns, but also including column F. The table rows in the mini sheet are sorted (partially manually) for...

Hello and thanks in advance for any assistance provided. I have written a function to group rows, but how can I modify it to avoid the error: "Run-time error '13': mismatch." on the line : Set RngGrpLast = RngGrp.Find(What:=GrpValue, After:=RngGrp(i - 1), SearchDirection:=xlPrevious) within...

Thank you for taking the time to help, I am using VBA to create a pivot table that will be used to view staffing / allocations over a number of dates. The data fields presently in the pivot table macro are separated in one column grouped in rows, Position 1 through to 4. "Actual work" is...

Hi All, I have data that comes in tab format. so have to summary the data with Value & Reference numbers by client. but with multiple transaction ID's and reference numbers im not able to arrange the summary the way my management want. They need Client Name > Reference Number for Sales >...

Haven't been able to find anything searching online. I am looking to understand if it is possible to assign grouped rows to the row above the group so that when applying filters to the data only the non grouped rows get moved around, bringing the group assigned to them to the next position in...

Hey, I need a way to calculate overlap between Groups but not within the same group. I need to make a template where a user can input the group name and the Numbers associate and have a easy checker to see if there is any overlap between the groups. Ideally there is a Button which runs a Macro...

I have below lines of code whare i am trying to group the dates in to month. below code is not grouping and at the same time not throwing any error. can someone help me with this. With ActiveSheet.PivotTables("Report").PivotFields("WEEK_END_DATE") .Orientation = xlColumnField...

Hi guys, Wonder if any of you have encountered a similar scenario: I've got a table similar to the following one, with a few hundreds of different entities where each of them have its own specific "length". Don't know how exactly explain it but I would like to group the Q by buckets of...

Hello! I have an excel like this: So I have column A, I want column B to complete automatically. I though that by entering a blank row between groups it will be easier to separate groups. So it will go down the column A and for each not empty row it will write Iph in column B, when it finds...

I have been trying to figure this out all day: I am building a dashboard, and I have everything in a summary tab (in a table) to pull for pivots. The dates do not seem to be recognized as dates when I try to use a pivot to group by date. I have tried text to columns, and formatting cells. I...

I need help, I'm on a MAC and don't know how to use VBA's. Previously I would have used MS Access, but.... Mac! Here is what my data looks like: PDP URL IMAGE URL IMAGE ALT TEXT abc.com/page1.html abc.com/images/banana.jpg Banana abc.com/page1.html abc.com/images/apple.jpg Apple...

Anyone able to provide some quick help? I have a worksheet I am working with to schedule fabrication. I need two macros to format the sheet and a background process. Macro 1: Button Labeled "Fab Start"; sorts by Column I "Planned Start" oldest to newest creates...

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...