00:00Hello, in this video, I will show you how you can reverse the data in a column from
00:07bottom to top in Excel with formula.
00:12For example, you can see that this is the column and here I have some fruits name.
00:18So if you want to reverse the fruits name, I mean to say that if you want to fake on
00:23the top of the list and then the coconut and then beer berries and simultaneously you
00:31want to put the apple on the bottom of the list.
00:34So this is very easy.
00:36So for this you need to do that, put the is equal to and use the index functions and then
00:46open the parenthesis or bracket and then select the array.
00:52You need to select the array and then before I you need to put the dollar signs and then
01:04after I you need to again put the dollar signs and here you need to again put the dollar
01:10signs and before 25 you need to put the dollar signs again and then comma and use the rows
01:21functions and then again open the parenthesis or bracket and select the array.
01:29It is the array and again you need to put the dollar signs before I and then after I
01:41and then close the bracket and then close the formula and this is the formula you need
01:48to write here and then press the enter and here you can see that the fig is on the top
01:55of the list and through fill handle you can drag it to the bottom of the list and here
02:03you can see that apple is on the bottom of the list and fig is on the top of the list
02:08and then coconut and beer berries and strawberry.
02:11So in this way with this formula you can easily reverse the data in a column from bottom to
02:17top in excel with formula.
02:20So I hope this video is helpful to you if you think the video is helpful please support
02:25my channel and also comment share and subscribe thank you very much.
Comments