![]() After sorting the data sometimes there is a third row containing the same value in D column, like so: The thing is that D values need to come in couples in every two sequential rows and for every data set I know that the E value for one of the duplicate D value rows must be lets say "George" for the sake of this example. So obviously the data has to be sorted by month, day, hour and some number in column D. and it goes like this for like say 1000 rows. D is "some string" and E is "someone's name" - they all look like this: So the situation is like this: I've got a 5 column data set A:E containing:Ī:C are: month, day and hour. OK, there are some pretty elegant solutions to the matter, but mine is a little different than the original problem of the topic! I know it's an old one but still I'm posting my request for help, so I beg you be generous ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |