Hi to all,

hope you can help me
below is the input data:

ID QTY CODE
-----------------------
213307 27 LS01
213307 0 DP02
213307 27 IN01
213303 6199 LS01
213303 0 DP02
213303 6199 IN01

I need an output like this

213307 27 DP02
213303 6199 DP02


I need a logic how can get the above output

hope you can help me

Thanks,
rylemer

What commended "DP02" over "LS01" and IN01 for each of the groups?

Can you be more specific about where the input data is coming from, and what you're outputting it to e.g. combo box, list box, DataGrid etc.