Results 1 to 8 of 8

Sorting and display groups of data entries

Threaded View

  1. 10-26-2020, 12:57 PM #1
    ben.cote
    ben.cote is offline
    Registered User
    Join Date
    04-29-2020
    Location
    Edmonton, AB
    MS-Off Ver
    Office 365, Office 2019
    Posts
    21

    Question Sorting and display groups of data entries

    I'm working on a COVID project to count pedestrians. I have the data output but I need a way to summarize it into a report.

    The formula has to find if the weather and road conditions have changed, and if they have changed, what period of time did they change over. If the count starts at 8:00 am with Sunny and Bare conditions and the weather and road conditions change at 9:00 am to Rain and Overcast, the Weather and Roads Report has to show that between 8:00 am and 9:00 am the conditions were Sunny and Bare. We do not require a full list of each entry over the time period from 8:00 am till 9:00 am just the summary.

    The sample has been simplified but the principles are the same.
    Last edited by ben.cote; 11-10-2020 at 01:38 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. sorting groups of data without changing the data within the groups
    By ChipW in forum Excel General
    Replies: 4
    Last Post: 07-22-2015, 07:13 AM
  2. How do I group multiple data entries in sub-groups
    By bj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 11:05 AM
  3. [SOLVED] How do I group multiple data entries in sub-groups
    By wendyrose1034 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. [SOLVED] How do I group multiple data entries in sub-groups
    By wendyrose1034 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  5. [SOLVED] How do I group multiple data entries in sub-groups
    By wendyrose1034 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  6. How do I group multiple data entries in sub-groups
    By wendyrose1034 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How do I group multiple data entries in sub-groups
    By wendyrose1034 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-27-2005, 12:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1