Reversing Column Order
Feb 16, 2007
I have a column of data I would like to have reversed on the fly (use functions and not vba). I have a function that works for the first cell but I can't seem to get it to work for the rest of the column when I choose edit/Fill Down.
=OFFSET(GI_Norm_list,MAX(ROW(GI_Norm_RevList))-ROW(),0)
where:
GI_Norm_list = column O
GI_Norm_RevList = Column V
I copy =OFFSET(GI_Norm_list,MAX(ROW(GI_Norm_RevList))-ROW(),0) to cell V1 and it works fine. I choose edit/fill down and I get #REF for every other cell. I seem to be doing this wrong somehow.
View 5 Replies
ADVERTISEMENT
Feb 20, 2007
Is there a way to reverse the order of data in a column - and maintain that same order but in reverse - so the last value in the column becomes the first, the second last value becomes the second, etc.
View 9 Replies
View Related
Dec 11, 2006
Can i take a name that is in "normal" order and change it so that it is in the format of "Lastname, Firstname Middlename" regardless of how many names are represented?
I have used a simple concatenate formula along with some left/right formulas to get this working if every single person in the list has only their first and last name, but I get errors if the person has 3 or more names listed.
So what I want, is a formula that will turn these names:
Carl Johnson
Carl Robert Johnson
Carl Joseph Robert Johnson
into these names:
Johnson, Carl
Johnson, Carl Robert
Johnson, Carl Joseph Robert
View 7 Replies
View Related
Apr 29, 2014
I'd like to reverse a column of numbers. The format of data is currently as follows:
Student ID
Years in Residence
12456
[Code]....
View 3 Replies
View Related
Dec 14, 2011
I want to simply flip the last name and first name in a column for alphabetical sorting purposes.
The names start in A4 and continue down and look exaclty like the format below including some middle initial or full name:
John Doe - $5,000.00
Jane Doe - $7,000.00
Tommy Chong - $50,000.00
Billy Bong - $25,000.00
Dave T Jones - $5,000.00
Alex Lee Johnson -$100,000.00
I want it to simply swap the first and last name order to look like this:
Doe, John - $5,000.00
Doe, Jane - $7,000.00
Chong, Tommy - $50,000.00
Bong, Billy - $25,000.00
Jones, Dave T - $5,000.00
Johnson, Alex Lee - $100,000.00
View 5 Replies
View Related
Mar 1, 2008
I need a way to re-order an excel worksheets columns based on another worksheet.
Data is extracted from a database into excel however users can configure the columns in the initial system. to how they like This causes problems when the data is copied into an excel spreadsheet I have created as the data copied will not be in the same column order as is required.
How can i reorder the columns without physically having to cut and paste the columns to match?
I have attached a sample spreadsheet.
You will see on the spreadsheet that 'fixed columns' is the order that i require the data however 'variable columns' is not in the same order.
View 3 Replies
View Related
Mar 25, 2009
imagine your data set (numbers are random and do not start in cell A1):
1
2
3
4
5
6
i need the entire data set reversed
6
5
4
3
2
1
i started trying to code this...... but quickly realized i havn't the slightest idea where to start
View 5 Replies
View Related
Aug 1, 2008
I know there is a way to do this, but I can't remember how! I have one cell (actually, thousands of cells) where the first name is listed and then the last name. I want to reverse the text so the last name appears first, and then the first name appears last, in the same cell. That way, I can alphabetize the columns by last name.
View 11 Replies
View Related
Jun 24, 2014
I accidentally replaced all my formulas from a format of:
=A1
to:
''''=A1
I would like to return to the original form:
=A1
However the Find/Replace command does not seem to recognize the first single quote.
View 2 Replies
View Related
Dec 28, 2011
I need to put the order in the second column of the item that is in the first column.
In the last line item Computer is recorded for the third time.
MATERIALSSEQUENCEComputer1Computer2Mouse1Mouse2Computer3
View 2 Replies
View Related
Nov 21, 2013
My colleague copies a date to the clipboard and then pastes it back onto the same spreadsheet. The month and day reverse (01/12/2013 becomes 12/01/2013). This doesn't happen when copying 14/12/2013 (probably because it can't be interpreted two ways) nor when avoiding the clipboard with ctrl-C/ctrl-V.
My working theory is that it's some kind of autotext or formatting function. Is there a way to disable this feature/function/glitch?
View 1 Replies
View Related
Dec 1, 2009
Is it possible to take a list that is alphabetized in the following manner--Jones, Mary--, convert it to Mary Jones while also removing the comma after the name?
The =TRIM and =MID formulas that I saw in another thread both seem to convert the text, but they also leave the comma at the end.
View 2 Replies
View Related
Jan 1, 1970
This doesn't work
View 13 Replies
View Related
Nov 29, 2012
I need to create random numbers with 10 columns and 10 rows.
But for each line can not be the number opposite each decade.
79
22
48
70
04
98
09
41
32
56
[Code] ........
see the first line was generated as the number 79, then this same line, can not generate the number 97.
number 22 in this case is OK.
The first line was generated the number 84, then this is not the same line, you can generate the number 48.
The first line was generated the number 07, then this is not the same line, you can generate the number 70.
and so
97
22
84
07
40
98
90
14
23
65
View 9 Replies
View Related
Nov 13, 2008
I have a range: AC2:AG1400 that are filled with numbers....
Someone manually highlighted, in bright yellow, some of the numbers.
I need a macro that could reverse the signs of only those that are coloured in that yellow.
View 9 Replies
View Related
Dec 24, 2008
I have a column that orders fine a-z except for the fact that it doesn't group words together with hyphens e.g.:
1.my-flies
2.myflies
3.my-fly
4.myfly
when I want it to be
1.my-flies
2.my-fly
3.myfly
4.myflies
View 10 Replies
View Related
Mar 28, 2009
Can I reverse the order of values in a column or row? [ie] first cell goes to last cell, last cell goes to first cell, middle cell stays where it is, etc. [and if so, how?].
View 5 Replies
View Related
Jul 19, 2013
I have a column that has something like:
7
5
3
6
4
9
3
11
(continues)
How do I make it to be the order of bigger number to smaller number?
I tried Data > sort Z-A, but then some of the numbers disappear and become "--"
View 2 Replies
View Related
Oct 27, 2013
I am trying to bulk upload some geo locations for my site, but the data I have is longtude first and latitude after, whereas the site accepts the data reverse, which means latitude, longitude.
that it's possible to change the order somehow.
Here is a example of how it looks:
"(12.595342677449292 55.66937339270993, 12.595097670457731 55.669239938648126)"
View 13 Replies
View Related
Dec 30, 2011
Any shortcut method to convert the row or column data in reverse order . for eg.
from A1 to F1 data is mentioned as 1,2,3,4,5,6 now i need the result from A2 to F2 is 6,5,4,3,2,1. and in another case data in A column from A1 to A6 like 1,2,3,4,5,6 and result needed in B column B1 to B6 is 6,5,4,3,2,1
View 6 Replies
View Related
Feb 17, 2013
i would like to rank a column so that when entering a number in a cell it will move up the column so that the greater number falls down the colum and the larger rises up the column
ie
list
6
5
7
8
9
1
3
2
4
------------------------
list
1
2
3
4
5
6
7
8
9
View 4 Replies
View Related
Apr 9, 2009
How do I transpose the values in a column of cells (so the value in the topmost cell in the old column becomes the value in the bottommost cell in a new column)?
View 6 Replies
View Related
Sep 1, 2009
I am trying to sort a column of data in ascending order but I am not getting the results I expect. An example of the data held in the cells is:
4972-1A
4972-10A
4972-2A
4972-1B
4972-3C
When I sort it in ascending order it sorts like:
4972-10A
4972-1A
4972-1B
4972-2A
4972-3C......................
View 4 Replies
View Related
Sep 6, 2005
How do you make a column automatically place items in alphabetical order?
Also, how do you make a column automatically put dates in order?
View 13 Replies
View Related
Dec 9, 2011
Looking for a dynamic macro to reorder columns in a worksheet from a list of column headings Column A in another worksheet.
View 3 Replies
View Related
Mar 26, 2012
I have a macro built that sorts my data by column in descending order depending on what column of information is selected from the drop down menu.
However I need the macro to sort column F in ascending order, and continue to sort the other colulmns in descending order when selected.
I can't get my macro to switch the sort from descending to ascending order for this one column. Looking to see if this is possible, and if so what macro formula I would use.
Here is what the macro i am currently using:
Sub ddSort_Click()
Dim iDdSortVal As Integer
Dim CurrSheet As String
Dim lFirstSectionRow As Long
Dim lLastSectionRow As Long
Dim strCol As String
Dim lRptHeaderRow As Long
Dim iRptMeasColumn As Integer
CurrSheet = ActiveSheet.Name
[Code] .......
View 1 Replies
View Related
Apr 8, 2012
Im am looking for a way of automatically sorting the data I have in column "C" (C2:C99 to be exact).
The data represents stock codes which are a mix of text and numbers, starting with 1 letter followed by numbers.
I would prefer something I can put in the sheet tab view code section, so that when any new data is added or altered it automatically sorts the stock codes in to alphabetical then numerical order
EG:
A10
A11
B13
B15
etc....
View 3 Replies
View Related
Feb 5, 2013
Ok, imagine this data (say column A). I want to have a cell that automatically searches for the least value (will always be the first number from top) and returns it in another cell. And then repeat the same for the second number from the top.
Beg Search STA
-
-
300
-
-
1050
-
-
2200
View 5 Replies
View Related
Jul 31, 2014
I want to refer to columns by column order (i.e. A=1, B=2, etc.)
I want to sum a range for dynamic columns and fixed widths (i.e. B2:B5 or F2:F5, etc).
i have C_N as variant and i am trying to write the formula but desperately getting syntax error.
Code:
Range("M5") = WorksheetFunction.Sum(Range(C_N& "2" : C_N&"5")))
i tried before to make another easier formula like
Code:
=Range("N5:N" & LastRow)
and it worked.
View 2 Replies
View Related
Nov 29, 2008
I looked at threads realted to printing but wasn ot able to find something similar to what I need. So here is my problem:
I have a file with more than 100 worksheets (each sheet contains the invoice for one store). I would like to create a macro that would enable me to determine the order in which worksheets would be printed. How to do it?
Idea #1: the printing order would be based on the value in cell L1 that would contain the route number for each store. Stores belonging to the same delivery route will have the same value in L1. So, the macro should first print all sheets with 1 in cell L1, then print all sheets with 2 in cell L1 and so on...
Idea #2: Creating a separate data sheet with the list of all stores and their corresponding route number. Let's say info is contained in range A1:B150, where Column A contains the name of the stores and column B contains the route numbers. The macro then should look at that list to determine the printing order of the subsequent worksheets (the name of the store in column A would be the same as the name of the worksheet corresponding to that store).
Idea #3: sorting my 150 worksheets manually. It does not solve my problem fully, though, because stores do not always belong to the same route. So the manual sorting should be carried out daily and would not save time at all.
View 9 Replies
View Related
