Help me to short this please?

L

leksa

I have a problem in short the data :


Code:
--------------------

Code Sum
BSC100044 76940
BSC100044 125915
BSC100044
BSC100052 125599
BSC100052
BSC100061 23730
BSC100079
BSC100087 127270
BSC100087
BSC100095 125251
BSC100095
BSC100108 125250
BSC100108
BSC100116 122283
BSC100116 128105
BSC100116
BSC100124 125982
BSC100124
BSC100132 125253
BSC100132
BSC100212 127787

--------------------


The problem is :
I have to list the code in row, no double code. But, the list must have
the parameter :
1. The code that double have the number in "Sum" and do not have the
number in "Sum" must listed as Oldest Data.
2. The code that Do not have Sum and not double, listed as Newest Data
3. The code that not double and have the Sum listed as Losted Data
 
Top