+ Reply to Thread
Results 1 to 6 of 6

Grouping Rows by Date & Providing a Total of Groups

Hybrid View

SuffolkLad Grouping Rows by Date &... 02-14-2018, 04:52 AM
sandy666 Re: Grouping Rows by Date &... 02-14-2018, 05:06 AM
SuffolkLad Re: Grouping Rows by Date &... 02-14-2018, 05:50 AM
sandy666 Re: Grouping Rows by Date &... 02-14-2018, 06:10 AM
SuffolkLad Re: Grouping Rows by Date &... 02-14-2018, 06:39 AM
sandy666 Re: Grouping Rows by Date &... 02-14-2018, 06:44 AM
  1. #1
    Registered User
    Join Date
    02-14-2018
    Location
    Suffolk, England
    MS-Off Ver
    V 16 for Mac & for Windows
    Posts
    3

    Grouping Rows by Date & Providing a Total of Groups

    Attached is a sample of a column of a workbook that is designed to record evaluation form responses for a charity.

    The spreadsheet is used to record all the responses for all the training courses undertaken - but it has come to light that various training courses have taken place for which no feedback forms have been submitted.
    Also, it appears some data for feedback forms have been entered with training dates that do not correspond to known bookings.
    Also, where multiple training courses take place on the same day - the feedback data is sometimes all being entered as one course, not separate courses.

    Currently, I am going through the workbook and literally trying to correct this manually. And I have at least a dozen more workbooks to go through to investigate and identify missing feedback.

    I was wondering if there is a way of automating this process as follows:

    A method of searching the column containing dates and grouping them together, whilst also creating a total of how many separate date groups have been identified.

    We can then use this total to compare with the bookings in the calendar to verify how many training sessions are missing feedback forms.

    Many thanks for any suggestions or help.
    Attached Files Attached Files
    Last edited by SuffolkLad; 02-14-2018 at 05:52 AM. Reason: did not attach worksheet

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Grouping Rows by Date & Providing a Total of Groups

    no excel file attached

    To attach an Excel file to your post,
    • desensitize data
    • remeber that your example should reflect structure and type of data
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  3. #3
    Registered User
    Join Date
    02-14-2018
    Location
    Suffolk, England
    MS-Off Ver
    V 16 for Mac & for Windows
    Posts
    3

    Re: Grouping Rows by Date & Providing a Total of Groups

    sorry, will fix this ommision - though i had attached it.

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Grouping Rows by Date & Providing a Total of Groups

    Because you're on Mac I can't give you PowerQuery solution so it will be a PivotTable
    You can group dates by days or months or years only or all together

    edit

    I added PowerQuery solution because I noticed you've 2016 for windows
    Attached Files Attached Files
    Last edited by sandy666; 02-14-2018 at 06:30 AM.

  5. #5
    Registered User
    Join Date
    02-14-2018
    Location
    Suffolk, England
    MS-Off Ver
    V 16 for Mac & for Windows
    Posts
    3

    Thumbs up Re: Grouping Rows by Date & Providing a Total of Groups

    The main spreadsheet itself is on a Windows based PC,which i also have at home, I just prefer to use a Mac where possible.

    So thank you for both solutions - especially the power query option as that will be for the platform the solution will be used on.
    I now have a few days to play it and master it ready to demonstrate and implement

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Grouping Rows by Date & Providing a Total of Groups

    You are welcome

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with grouping data and calculating averages from groups
    By SH1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-17-2020, 03:57 PM
  2. Grouping a Set of Numbers based on Difference between Groups
    By GREGOBR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2017, 01:07 PM
  3. [SOLVED] IFERROR is providing correct answer but not providing a blank Cell when it should
    By marshallmr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2016, 01:46 PM
  4. [SOLVED] Grouping Dates into Days and times into Groups
    By mgmerv in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-28-2015, 05:49 AM
  5. Replies: 4
    Last Post: 07-08-2015, 12:05 PM
  6. Grouping and Ranking within Groups
    By penfold in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-21-2010, 01:05 PM
  7. Grouping and grouping within groups
    By j-giesler in forum Excel General
    Replies: 1
    Last Post: 01-31-2006, 04:35 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1