group2

  1. J

    Day of Week averages after summing totals by date

    I'm working with call center data. I have call volumes for multiple groups by date, using the TEXT function to return the day of week. Like so: 06/03/19 Mon Group1 1000 06/03/19 Mon Group2 1400 06/04/19 Tue Group1 1100 06/04/19 Tue Group2 1500...
  2. G

    Stumped - SUMIFS for Horizontal and Vertical Criteria

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

    SUM function with LOOKUP to a Dynamic List

    Hi all, I am having some trouble summing up some data from the dynamic range B2:C15. All the fruit names that populate $B$2:$B$15 belong to to either of the 4 groups. These 4 groups are also dynamic lists. They are: Group1: Range $E$3:$E$15, Group2: Range $F$3:$F$15, Group3: Range...
  4. S

    Loop through data, copy various values to new row on another tab

    Worksheet1 <tbody> LastName FirstName Code ID E Group Address H Group2 Address2 K Group3 Address3 Smith John 01, 03 123456 Place1 123 Main St. Jones Fred 06 852547 Place1 123 Main St. Place2 345 Water St. Place3 567 High St. White Barb 03, 123, 04 258787 Place1 123 Main St...
  5. X

    group

    Hello friends I want to do three or more groups but I can not do it Combines everyone Please help me, <tbody> group1 group1 group2 group2 group3 group3 group3 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 </tbody> <tbody> </tbody>
  6. R

    Breakdown data in groups by relation

    Hello everybody, I have a quite large data sets (70.000) and would like your help. Data sets looks as follows: <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> COL1 (orderid) COL2 (prod.id) group1 230 group1 501 group2 1231 group2...
  7. S

    How to summarize a text planning grid?

    So not sure quite what I'm asking here, but seeing if you could give me pointers? Let's say I've got a planning table like this below. I'm trying to think of a way to have a second table that will list each ToolID and a single cell that shows all the 'items' that have X for them, dynamically...
  8. D

    Delete all associated variables in a listbox items with same value

    Hello all. I'm sure this is possible but I think I may be venturing into arrays, which I don't have a lot of understanding of. I have a listbox that populates a range of values (Strings) from a sheet. Each string value has a unique value attributed to it, however there are only a handful of...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top