group by data

Hello everyone, It's my first time posting here. My knowledge in Excel is ever improving but is not as complex as some of the threads I've read here. So I think I'm in the right place. I have a sheet that looks like this: KEY1 58 31 58 29 31 KEY2 18 12 18 KEY3 70 71 70 70 70 What I...

There might be a much easier way of doing this, but I'm struggling to come up with a solution. I have columns month, person and payments. A month can have multiple persons, and not all people need to appear every month. What I want to return is the payment sum per month as well as a sum of...

I'm working in movies as an AD. I need to prepare a schedule and provide artist-wise dates to my team. Every time I'm doing it manually by checking the scenes. Can anyone suggest an idea or workaround which could make this work easy? If there is any way please let me know. Present template...

Hello All, Hope you are doing Fine. I have Excel data as shown in the below table. Can anyone help me to get the desired output? SCENE NUMBER CHARACTER NAME E01 SC 01 MICHAEL E01 SC 01 JACK E01 SC 01 ELIZABETH E01 SC 02 JOHN E01 SC 02 MICHAEL E01 SC 03 JACK E01 SC 03...

Hi There, I wonder if someone can help me? I have a series of data (~700 rows, 5 columns) that I am looking to allocate into 5 groups using a random function and based on a series of rules / criteria that I would like to apply. I wondering if there is a simple formula that I can apply to the...

Hi Guys, Can you possibly help me on creating a macro that groups data based on below sample criteria: Raw Data: <tbody> ID Team Name Status Date Type 1 Math Ana Closed <tbody> 9/21/2017 </tbody> <tbody> Critical </tbody> 2 Math Seff Open <tbody> 9/29/2017 </tbody> 3 Math...

Hello, I have a 4 sales reports I will be running on a weekly basis the rows of data will vary from 2,000-3,000+ I need to take this info sort it from highest selling store to lowest then group them evenly in segments of 10. Segment 1 would have the top selling stores Segment 10 would have the...

Hi all, I have a quick question about performing "group by" in excel. I currently have to 2 columns named, "name"' and "number" as shown below. Name Number Balance 2000 Balance 300 Balance 200 Sales Deduction 20 Sales Deduction 30 ROI 20 ROI 10 Balance 29 Sales Deduction 1000 ROI 90 Sales...