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

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