hkteo80
04-01-2011, 09:59 PM
Hello guys,
I try to write a vba code to eliminate data like this below
My input data:
Ht1.600//cannot be remove
.... //some other data
Ht1.600
......//some other data
Ht1.600
.....//some other data
Ht1.600
....//some other data
Ht1.500//cannot be remove
....//some other data
......//some other data
Ht1.500
....//some other data
Ht1.500
My output data:
Ht1.600
......//other data
.....
......
.....
Ht1.500
.....// other data
......
....
.....
what can i do to eliminate these extra "Ht" data similar value to the first one e.g. Ht 1.600 and Ht1.600 the second value will be delete, whereas Ht1.600 and Ht1.500 none of the value will be deleted?? The output is the value i want it to be.. Can anyone please help me with this one. Thank you
I try to write a vba code to eliminate data like this below
My input data:
Ht1.600//cannot be remove
.... //some other data
Ht1.600
......//some other data
Ht1.600
.....//some other data
Ht1.600
....//some other data
Ht1.500//cannot be remove
....//some other data
......//some other data
Ht1.500
....//some other data
Ht1.500
My output data:
Ht1.600
......//other data
.....
......
.....
Ht1.500
.....// other data
......
....
.....
what can i do to eliminate these extra "Ht" data similar value to the first one e.g. Ht 1.600 and Ht1.600 the second value will be delete, whereas Ht1.600 and Ht1.500 none of the value will be deleted?? The output is the value i want it to be.. Can anyone please help me with this one. Thank you