Sorting cells values
I have values (digits) in square A1:E10
Some of the cell have value, some are empty.
It depends of other function to insert those values in that A1:E10 box.
Now I would like to transfer all available values from that A1:E10 box
to the cells of one single column for sample G1:G50.
How it can be done if possible?
Sorting cells values
Since you used the word "Sorting"in your subject line, this formula will return any values in A1:E10, sorted in descending order:
Enter the formula in G1 and drag it down to G50.
=IF(ISERROR(LARGE($A$1:$E$10,ROW())),"",LARGE($A$1:$E$10,ROW()))
Sorting cells values
Well,it is very strange, because that formula perform perfectly when implemented in very plain and straight form.
When I try to adopt it in my spreadsheet according to my needs it behave unpredictably. By unpredictably I mean that sometimes the numbers can be read, other time not at all or missing some of them and in some cases partially or not sorting them at all.
I do not know if this is the case that the digits in A1:E10
are as result of other calculating functions, not straight
taped numbers, and causing the problem.
By the way it is possible to extract those numbers from A1:E10 to designated column without sorting.
It looks that I have find where is my problem with that formula.
I notice that if I apply that formula in my spreadsheet and location of box A1:E10 and column change, it is not working.
It would be nice to be able to apply it to any location on the spreadsheet of the box A1:E10 and as well to be able to choose the column and row where the results can be printed.