I would like to sort some rows depending on the last used column. Is that possible?
For example:
Row 5 ends in Column 34
Row 6 ends in Column 12
Row 7 ends in Column 15
Row 8 ends in Column 29
Row 9 ends in Column 45
Therefore the sort should be:
"Row 6"
"Row 7"
"Row 8"
"Row 5"
"Row 9"
Im confused, what do you mean by sort some rows?
My understanding would be to sort those rows into order altogether, Im not sure how youre looking to sort one row? or do you mean sorting the first 33 columns in row 5?
Can you create and upload a sample sheet?
IGNORE THIS - I WAS HAVING A DIM MOMENT/ YEAR
Last edited by pjwhitfield; 11-18-2016 at 03:44 AM.
If someone has helped you then please add to their Reputation
Maybe:
Please Login or Register to view this content.
Apologies, yet again my brain wasnt functioning:
Id create a new column way further along the sheet than is possible to have data (Ive gone for CA in the example). in it add the following formula and drag down.
This will populate that column with the last item in each row, you can now sort on column CA, filter on it etcPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks