Hi Sharp, Sorry for the delayed response.. Please find my requirements in detail: There are three column named group,newstore,modelid My inputs are as follows: Group Newstore Modelid 10549 6453 5582 10549 6453 5217 10549 6453 2871 10549 2001 5582 10549 2001 5217 10549 2001 2871 10548 9648 6453 10548 9648 3251 10548 9648 2205 10548 9453 6453 10548 9453 3251 10548 9453 2205 Here the newstore 6453 and 2001 belong to the same group 10549. For 10549 group there will be three model id (5582,5217,2871) . it varies based up on group number. i need to selce the unique newstore and its group,modelid but the model id shoul not contain duplicates. My output as follows: `Group Newstore Modelid 10549 6453 5582 10549 2001 5217 10548 9648 6453 10548 9453 2205 here in output you can see the unique newstore value and its corresponding group and modelid. where modelid will not have any duplicates. Hope my requirement is clear now it .I need to know whether this can be possible.if yes,how can i achieve that. I tried a lot but no luck.:smileycry: Thanks, Siva.
... View more