A Angelo May 22, 2004 #1 I would like to know if exists a method for reversing the order of data contained in lines in columns ... Angelo ITALY
I would like to know if exists a method for reversing the order of data contained in lines in columns ... Angelo ITALY
P Peo Sjoblom May 22, 2004 #2 Use a help column/row, put 1, 2, 3 and so on, then sort descending with the help column/row as key -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
Use a help column/row, put 1, 2, 3 and so on, then sort descending with the help column/row as key -- For everyone's benefit keep the discussion in the newsgroup. Regards, Peo Sjoblom
D David McRitchie May 22, 2004 #3 Hi Angelo, (macro solution) If you want to reverse the order in place, and especially if you want to do it often, you can use a macro. Reverse Cells in Selection end for end (#reversi) http://www.mvps.org/dmcritchie/excel/join.htm#reversi Even a macro to reverse the characters within a cell. http://www.mvps.org/dmcritchie/excel/strings.htm (see reverse)
Hi Angelo, (macro solution) If you want to reverse the order in place, and especially if you want to do it often, you can use a macro. Reverse Cells in Selection end for end (#reversi) http://www.mvps.org/dmcritchie/excel/join.htm#reversi Even a macro to reverse the characters within a cell. http://www.mvps.org/dmcritchie/excel/strings.htm (see reverse)
I ivano May 23, 2004 #4 Puoi postare pure in microsoft.public.it.office.excel In italiano..per noi più semplice!
