Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locating First and Last Cell Containing a Specific Value
Hello,
I have data in several columns, the first being a date and timestamp and the second being an identifier (numeric). The numeric identifier occurs repeatedly at different times (each identifier appears in numerous rows). I would like a way of extracting the timestamp of the first and last occurrence of an identifier. A:A contains Timestamp B:B contains Identifier (not unique) Ideally, given a particular Identifier, I would like to write a formula that would return the timestamp of its first occurrence and another that would return the last occurence. I've tried multiple suggestions including ADDRESS and various LOOKUPs, but no luck yet. Thanks for any suggestions! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locating First and Last Cell Containing a Specific Value
1. sort the data by column A (the stamp)
2. autofilter by column B (the ident) the first visible entry is the first value that last visible entry is the laster entry for that ident -- Gary's Student " wrote: Hello, I have data in several columns, the first being a date and timestamp and the second being an identifier (numeric). The numeric identifier occurs repeatedly at different times (each identifier appears in numerous rows). I would like a way of extracting the timestamp of the first and last occurrence of an identifier. A:A contains Timestamp B:B contains Identifier (not unique) Ideally, given a particular Identifier, I would like to write a formula that would return the timestamp of its first occurrence and another that would return the last occurence. I've tried multiple suggestions including ADDRESS and various LOOKUPs, but no luck yet. Thanks for any suggestions! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|