Results 1 to 6 of 6

Grouping Rows by Date & Providing a Total of Groups

Threaded 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

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