Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a very large s/s that has a lot of recurring data in it. It is broken
into sections (not w/s) by date. I need to see only the first occurance of each name in each section. For example, here is a sample: 1/1/2005 Time Reader Person 5:53:40 AM 0 Doe, John 5:56:35 AM 3 Smith, Mary 6:10:31 AM 0 Doe, John 6:14:19 AM 13 Doe, John 6:34:57 AM 13 Brown, Harry 6:37:31 AM 11 Smith, Mary 1/1/2005 5:49:48 AM 0 Smith, Mary 5:53:24 AM 3 Smith, Mary 5:56:44 AM 0 Brown, Harry 6:10:34 AM 13 Doe, John 6:11:01 AM 13 Brown, Harry 6:18:57 AM 11 Smith, Mary What I want to see is this: 1/1/2005 Time Reader Person 5:53:40 AM 0 Doe, John 5:56:35 AM 3 Smith, Mary 6:34:57 AM 13 Brown, Harry 1/1/2005 5:49:48 AM 0 Smith, Mary 5:56:44 AM 0 Brown, Harry 6:10:34 AM 13 Doe, John TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) | |||
I want ascending numbers to show up in a cell of my spreadsheet | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Applying Existing Password to New Spreadsheet | Excel Discussion (Misc queries) | |||
I need to have only the values show in a spreadsheet. | Excel Worksheet Functions |