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

Help!! find two number recurring numbers in row?? 1
Reverse Index Match 2
macro help 1
Need to pull <=14 Days, <=30 Days, >30 Days from a date column 3
How to determine the higest value? 4
Find then highlight in yellow 6
How to determine the values based on given conditions? 11
Modifying a complex date formual to count months 4

Top