Display last entry/row only when data changes

C

cstephenspi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro help 1
What is an automatic way to delete all rows of a certain kind 1
Count based on multiple criteria 2
Excel 2002: How to condition format rows with empty cells ? 6
Date Difference 2
Compare cells 1
How to solve a complex problem using Excel 2003 2
Find then highlight in yellow 6

Top