Hello everyone,
I have a column with blanks , I want to sort them in another column sequentially ,, any idea ?
Thanks in advance
Hello everyone,
I have a column with blanks , I want to sort them in another column sequentially ,, any idea ?
Thanks in advance
Is this an Excel question, or a Googlesheets question, or what???
This will work with Excel 2010+. I have no idea if there is an equivalent in GS:
=IFERROR(INDEX(D:D,AGGREGATE(15,6,ROW($D$2:$D$19)/($D$2:$D$19<>""),ROWS(G$2:G2))),"")
copied down. See sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Glenn ,,
Thanks a lot , yes it works with office as you explained , I am on google sheet unfortunately ,
I tried to upload it maybe google sheet can do something , but didt work out , do you know how to do it with GoogleSheets ?
Maybe
=SORT(FILTER(C3:C20,C3:C20<>""))
For Google Sheets, if column A has the numbers with spaces, put the following in the column you want the sorted numbers:
=SORT(A1:A,1,TRUE)
Glad to help & thanks for the feedback
ElGendi, Change the TRUE to FALSE
Hi,
Excuse me , I did mean the (Fluff13 ) formula , the one I want to reverse , but while trying yours as well worked out , and the reverse was resolved as well , but it's very down to the list no in the upside where I did type the formula
just for reference for whoever might need it, I used
=LARGE(AB1588:AB1637,1)
=LARGE(AB1588:AB1637,2)
=LARGE(AB1588:AB1637,3)
=small(AA1588:AA1637,1)
=small(AA1588:AA1637,2)
=small(AA1588:AA1637,3)
of course my solution is good with small entries , but the above ones from our friends would be efficient in case you are dealing with large scale.
Thanks all for your time.
Regards!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks