group1

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

    Quick lookup check

    What's the easiest way of me checking multiple columns between 2 worksheets? I have two documents, both having the same columns such as: <tbody> A B C D 1 ACTION TYPE TIER 1 TIER2 TIER3 2 Reporting GROUP1 GROUP4 3 Manager GROUP2 GROUP4 4 Access management GROUP1 GROUP3 5 so on...
  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. 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...
  7. D

    Combine selection from multiple checkboxes

    First, I am new to VBA and this is my very first time posting a question. Please let me know if I should provide additional detail, etc. Here goes… I have a worksheet (built with MS Excel 2013) with a table and graph. There are VBA checkboxes built in so the end user can make a selection to...

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