Hi guys!
New here and here goes my first post!
I need help with a formula that sorts several rows for me while keeping the right values in the right place - really hard to explain so I'm gonna goa ahead and show it instead:
Let say I have several rows with several columns with different value in each cell.
But at the end of 1st row (the last cell) I have a value of A, in the end of 2nd row I have a value of B, in the end of 3rd row I have again a value of A and in the end of 4th row I have the value of B again.
And this will go on for all the following rows in the sheet.Please Login or Register to view this content.
I need to allways keep this sorting. So lets say If I remove the 2nd row completely (which I will need to do in the project that I'm working on) then I would get the values AABABABAB.
What I need it to do then is to move up the the next row with the value of B (in this example the row the number of 4 infront )and put that row between the rows 1 and 3 and keep doing this for all the rows and end up with this:
The idea is to allways sort so that A allways follows by B and so on.Please Login or Register to view this content.
The Values A and B can be replaced by 1 and 2 or 100 and 200. It really doesn't matter as long as the formula keeps the original sorting.
In the end, when removing a row, all it needs to do is to move all the rows with the values of B one step up and again het the ABABAB sorting in place
I hope I managed to explain it good enough, otherwise let me know and I try to explain it again
Thanks in advance!
//virre
Bookmarks