|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating a Custom List that Updates when one of the data fields is filtered
I am working with an excel spreadsheet of traffic counter data for three lanes of traffic in a street. The lanes are coded as "SB1", "SB2", and "SB3," and are all contained in one column. Unfortunately, the timestamps for these transmissions are not coded as either AM or PM. There are two identical timestamps for each lane, but they are definitely different datapoints. They are in such a consistency that I can create an automatic list that reads "AM" and then "PM" in every other cell.
To ensure optimal accuracy, I wish to run such a list when my workbook is filtered for one of the three lanes (SB1, SB2, and SB3). That is, I want "AM" for every other row that contains "SB1", and "PM" for all remaining rows that contain "SB1." Does Excel have that capability? Do I have to write a macro to do this? |
#2
|
||||
|
||||
It's not at all apparent to me how your AM/PM times are differentiated. When I filter on SB1, I see that your 'AM or PM' column has nothing for the first few rows, then 2 PM entries followed by 5 AM entries, 2 PM entries, 1 AM entry, 1 PM entry, 2PM entries, etc. I can't see how this relates to:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook Meeting Invite Distribution List Attendee updates | kdogg121 | Outlook | 2 | 06-21-2017 11:58 AM |
Creating a table that automatically updates based on entries of a heading in the document | cahphoenix | Word | 3 | 10-29-2014 01:11 PM |
Populate Word Drop-down list with Excel column then auto fill form fields with Excel data | Faldinio | Word VBA | 7 | 10-19-2014 06:03 AM |
How to automatically sum in excel for filtered data | msi_g | Excel | 2 | 08-05-2013 05:29 AM |
Custom Fields : Creating New Field Types. | KarthikR | Word | 0 | 12-04-2005 12:47 PM |