Everyone has been so helpful on this forum; there are really some true experts. I’m making tracks with Excel but have really hit a stumbling block which seems like it should be an easy fix but I just can’t work it out.

So I’m taking data from Cells B2, O64 on sheet named ‘Remove 0s’

I’m transpose and alphabetising this information into Cells B2, 064 on sheet named ‘Alphabetised’

I’m using the formula

=SORTBY(‘Remove 0s’!B3:O64, ‘Remove 0s’!B3:B64, 1)

I need to cover that range of cells as more data may appear in the other rows up to row 64. As you can see from the picture, it is in ascending order however it has prioritised all of the blank cells first. I need those at the bottom.

Please could someone be so kind as to help me out. It’s hugely appreciated.

Thanks

Graeme

​Everyone has been so helpful on this forum; there are really some true experts. I’m making tracks with Excel but have really hit a stumbling block which seems like it should be an easy fix but I just can’t work it out.  So I’m taking data from Cells B2, O64 on sheet named ‘Remove 0s’ I’m transpose and alphabetising this information into Cells B2, 064 on sheet named ‘Alphabetised’ I’m using the formula =SORTBY(‘Remove 0s’!B3:O64, ‘Remove 0s’!B3:B64, 1) I need to cover that range of cells as more data may appear in the other rows up to row 64. As you can see from the picture, it is in ascending order however it has prioritised all of the blank cells first. I need those at the bottom.  Please could someone be so kind as to help me out. It’s hugely appreciated. ThanksGraeme    Read More

​