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
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.
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.
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.
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.
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?
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
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.
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.
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.
I would have like a chance to be able to remove the apparent potenitial dangerous problem from the thread below and not close it after 10 mins. I'm not on the site permenantly and keep dipping back in eveynow and again. I dont know what the issue is as when I open the file up I dont get any error messages. I have tried this on my machine using Office 2003 and Vista also another PC using Office 2003 and XP
[url]
The only error I get is a message saying Disk or Network error, when testing it on the XP Machine this is because doesnt have access to the Database it sends the data to.
I'm trying to find 4 digit duplicate in any order from 0-9 in 4 different columns and because they are from 0-9 in each column it doesn't seem possible.
I have a master order sheet with 100's of items on it which I use to go through my stock room and enter the qty's I would need to order. I have then created a seperate sheet that I use as a P/O to my supplier, this picks up all the info from my order sheet. everything works well except when I do NOT need a paticilaur item. On the P/O it still shows but with 0 qty, I would rather it not show at all and move on to the next item that does have a QTY.
I have a list of some 200 odd items on one sheet that is my price list; what I would like to do is have another person - who may only have very basic, or virtually no excel skills at all, be able to select items from the price list and have each of those items go to the top of an order form on another page.
It needs to be automatic, and anybody that has only basic excel should be able to use it.
I have several checkbox and adjacent to it there is a textbox. Also I have a command button. On Form initialize, all checkbox and textbox are hidden, except first check box and textbox. The first checkbox1 is enabled and textbox1 is empty. On Exit event of textbox1, the checkbox2 and textbox2 gets visible, with checkbox2 enabled.
On exit event of textbox1, the cursor goes to command button on Tab My requirement: The cursor should go to textbox2.
Note:- I have Tabindex set to as following: Textbox1 = 0 Textbox2 = 1 Commandbutton1 = 2
I need a macro that will copy a row from Sheet1 and paste it in sheet2 but the row must be inserted in ascending order based on the enties in sheet2. The order in sheet2 should follow colums A, B & C
The tab order in an Excel spreadsheet is driving me nuts. I could not get it on my own and found some code that seemed to solve my initial problem. However, I still can not figure out why I can't go backwards. It will ONLY go forward no matter what you do. If you try to select a cell behind or in front, it just tabs to the next cell in the array. Can anyone help before end up sitting in the corner of the nut house crossed-eyed and drooling
I need to create many XY charts in a VBA macro. For each chart, I need to select a particular column for the X dimension, and a particular column for the Y dimension. When I use a named range to define the X and Y columns, my macro works fine for those instances when the X comes first. However, if my desired Y dimension comes first, I cannot find a way to correctly select these.
The context is such that my spreadsheet always has the same data fields in the same columns, but the numbers of rows vary. In addition, I need to dynamically select which rows to use, based on the values in the columns to be plotted. I’ve figured out how to do this within the macro, except for those instances when the Y column comes before the X. An example when this works:
In the above example, variable ‘FirstBias’ is computed previously in the macro. I realize that I can rearrange columns in my spreadsheet to avoid this, but that is much less convenient, and less elegant, and I think there must be a way for a macro to do this automatically. I can do it interactively by cutting and pasting the data ranges in the chart wizard dialog, but I need this to be automated. I also figured out how to automate it in the case where the X and Y columns have fixed rows, by adding the commands below:....................
