Hello everybody,
I hope I can find here some help or ideas for solving the next issue: I'm an electric engineer who works with a software able to export lists under the excel format. Those lists include several times repeated elements in the cells.....As an image is better than thousand words, I just want to show you the next screen capture .
In this screen capture you can see that it is repeated, for instance, the element "KA13" 5 times. What I'd like to do is to get the exported lists "lighter" by removing the repeated 4 of the five repeated rows. I guess this must be done randomly since the adjacent cells in the same row have no logical conection between . I mean that you can't sort them by any criteria: The A column format is an index of pages and the B, C and D are referred to other parameters.
Any ideas of how to implement an excel program for achieving this?
Thanks in advance
Bookmarks