Thread: Criteria based editing of cells

Hello Guyz,



S/no Ref

5634 RXOCF-23 to be deleted
5634 RXOTRX-23-11
5634 RXOTRX-23-12 Should be combined
3234 RXOTX-2
2234 RXOCF-12 to be deleted
2234 RXOTRX-12-1 to be deleted
2234 RXOTX-12-1


and ouput should be as follows

5634 RXOTRX-23-11&-12
3234 RXOTX-2
2234 RXOTX-12-1



Note : The page used to have a lot of data i this order

S/n>Ref

for a particular s/no there will be multiple entries like Ref on

CF-xx
TRX-xx-yy
TRX-xx-yy1
TX-xx-yy
TX-xx-yy1 and so on

My aim is to get only one entry for a S.no with particular 'xx' which has the lower most REF, combining multiple yy's

in above eg

it should be


S/no TX-xx-yy&yy1


plz help me to generator a macro for the same...


Thx in advance

Kindly contact me if u require any sample sheet.

Please provide a usable sample data workbook, 10-20 rows should suffice.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

=======
NOTE: Please EDIT the original post, click GO ADVANCED and remove the "Help" from the title, it is against the forum rules. Titles should succinctly and professionally state the topic only.

Thank you, test file attached.