Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display last entry/row only when data changes
Column A is a code
Column B is order number Column C is the code date Column D is the code time Column E is the user I want to only display the last row of data when the order number changes. Each order can have different codes, different number of codes, and end with a different code. Below I only need to see CLS 500193 5/14/07 10:51 CLS on a row the next row would be INV 500384 5/31/07 9:26 CLS I just need the last entry for each order number Code Order# Code Date Code Time User CPI 500193 5/11/07 7:33 WJP PCK 5/11/07 7:34 CONT CFM 5/14/07 9:09 CLS ENT 5/14/07 9:09 CLS INV 5/14/07 10:51 CLS CLS 5/14/07 10:51 CLS QCV 500384 5/17/07 10:27 WJP CHG 5/17/07 10:28 WJP ACK 5/17/07 10:30 WJP EML 5/17/07 10:30 WJP CFM 5/31/07 9:25 CLS INV 5/31/07 9:26 CLS CPI 500387 5/17/07 11:00 WJP PCK 5/17/07 11:03 CONT ACK 5/17/07 11:04 WJP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display last entry/row only when data changes
I forgt to include that I am using Excel 2000
"cstephenspi" wrote: Column A is a code Column B is order number Column C is the code date Column D is the code time Column E is the user I want to only display the last row of data when the order number changes. Each order can have different codes, different number of codes, and end with a different code. Below I only need to see CLS 500193 5/14/07 10:51 CLS on a row the next row would be INV 500384 5/31/07 9:26 CLS I just need the last entry for each order number Code Order# Code Date Code Time User CPI 500193 5/11/07 7:33 WJP PCK 5/11/07 7:34 CONT CFM 5/14/07 9:09 CLS ENT 5/14/07 9:09 CLS INV 5/14/07 10:51 CLS CLS 5/14/07 10:51 CLS QCV 500384 5/17/07 10:27 WJP CHG 5/17/07 10:28 WJP ACK 5/17/07 10:30 WJP EML 5/17/07 10:30 WJP CFM 5/31/07 9:25 CLS INV 5/31/07 9:26 CLS CPI 500387 5/17/07 11:00 WJP PCK 5/17/07 11:03 CONT ACK 5/17/07 11:04 WJP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I display the last entry in a list | New Users to Excel | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
How do i have a check display with any data entry in a cell | Excel Discussion (Misc queries) | |||
Display Last Entry in Excel | Excel Worksheet Functions | |||
display last entry in Excel | Charts and Charting in Excel |