Forum Discussion

Copper Contributor

Apr 19, 2023

sort column descending - but not alphabetically

I have a column of data which I want to flip. So the bottom of the column becomes the top and the top becomes the bottom, but I don't want it to be alphabetically, I need the data in order, just flip...

excel

training

chealy79

Copper Contributor

Apr 19, 2023

Hello Quadruple Pawn, thanks for your quick suggestion... I'm not sure though if this may work in my scenario... I have a column of text, that I simply copy from a table, but I need to reverse the order and then enter a text in the cell next to it.... as you can see from my image I'll try and attach.

OliverScheurich

Gold Contributor

Apr 19, 2023

chealy79

Is the data in the left column already in reverse order or is this the unsorted data? And can you share the rule for the text you want to add in the adjacent cell? Perhaps you give an example of the text that you copy from a table and of the data in reverse order.

chealy79
Copper Contributor
Apr 19, 2023
OliverScheurich Currently I am viewing the data on the web list, and then manually entering my data list in column C. I then enter column d to update my action. What I would like to do is copy the weblist into a Column, and then sort it with excel into reverse order. So the bottom of my web list, is the top of my todo list.
- OliverScheurich
  Gold Contributor
  Apr 19, 2023
  chealy79
  =INDEX(A:A,COUNTA(A3:$A$1048575)+2)
  An alternative could be this formula in cell C3 which you can fill down. The already suggested formula along with a helper column returns the same result in my sheet.