putting a column of names into alphabetical order

I have collected data with names against dates and treatments and wish to 
rearrange the spreadshett into alphabetical order by name. 
 Some names have spaces in the name column as there may be multiple entries 
of other date in other columns.
I have merged and centred these cells in the "name" column.
I still get "cant merge". Have excel2003. maybe I should take my work home 
and see if 2007 excel can do the job
0
Utf
11/15/2009 10:06:01 AM
excel.misc 78881 articles. 3 followers. Follow

1 Replies
2832 Views

Similar Articles

[PageSpeed] 34

You shouldn't need to merge the cells to sort them.  Hopefully you still have 
an original, unmerged, copy of the data.

Simply select all columns with data in them and the use Data-->Sort and 
choose to sort them by the name column, all the other related columns will 
"follow" along with the correct names.

I'm not certain why you're getting a "can't merge" message, but when you try 
to merge 2 or more cells with data in both of them, Excel will basically want 
to delete the data from all but 1 of the cells.

"ElGordo" wrote:

> I have collected data with names against dates and treatments and wish to 
> rearrange the spreadshett into alphabetical order by name. 
>  Some names have spaces in the name column as there may be multiple entries 
> of other date in other columns.
> I have merged and centred these cells in the "name" column.
> I still get "cant merge". Have excel2003. maybe I should take my work home 
> and see if 2007 excel can do the job
0
Utf
11/15/2009 12:41:02 PM
Reply:

Similar Artilces:

PUTTING NUMBERS IN A CELL
I AM TRYING TO ENTER A NUMBER THAT BEGINS WITH ZERO'S AFTER I ENTER IT THE ZERO'S DISAPPEAR, HOW DO I KEEP THEM IN Please turn off the CAPS Lock, more than two lines would be extremely difficult to read. Reading caps is annoying. Format the column as text, if the leading zero is important to you then it is an identification not a number. The default alignment for text is left aligned which is also better for most identification "numbers". Credit card numbers are 16 digits, are identification and can not be entered as numbers, ever, because Excel only retains 15 si...

Column Search
Hi I would like to know if it is possible to do the following in Excel 2003. I have a number of columns of data which are used by various worksheets. My latest dilema is how do I find the first occurance of two different numbers in two column of figures and match it with a value in an adjacent cell; which will be the result of a formula. In other words I want to find the 1st occurance of 1234 in column A along with the first occurance of 789 in column B and where they match return the value in column C. Hoping for a speedy solution ...thanks -- Spellbound -----------------------------...

Mailbox name not changing
Hi there, Found a user recently with an incorrect mailbox name and tracked it back to the AD object having the incorrect surname. This was then changed but the mailbox did not update unless we did it manually by re-resolving her login through profile settings etc Is there anyway of setting this up as an automatic process? Many thanks, On 16 Nov 2006 04:50:05 -0800, "stuartmackillop@googlemail.com" <stuartmackillop@googlemail.com> wrote: >Hi there, > >Found a user recently with an incorrect mailbox name and tracked it >back to the AD object having the incorrec...

Lost Purchase order going over to Quick Books
Does anyone know how to see a report that contains purchase order information on what is contained in a batch that goes over to Quick Books? We closed a purchase order and it never went over to quick books after batch out. I went to knowledge base and pulled up "You cannot export a closed purchase order from Microsoft Point of Sale to Intuit Quickbooks (899318) but the directions to do the workaround make absolutely no sense, almost as if it applies to another version of RMS store operations. Jack , I know that you probably checked this , but just in case....A note: Double check...

Microsoft Management reporter migration from Frx
I ran the Microsoft Management Report migration wizard. Several reports have an entry in the Row definitions for CBR as a format code and in the "Related Rows" and entry for 195 the row for our Net Sales. In the column definitions we have a formula of B/CBR%. CBR% is generates an error that % is an unexpected character and removing the % I get an error that CBR is not a valid cell reference. The help file seems to indicated that BASEROW should replace CBR but BASEROW is not a selectable option in the Row definitions as a format code. Any idea? ...

How to copy the function SUM but offseted in 7 columns
I Have the folow situation : The cells content is: A1 = 50, B1 = 30, C1 = 40, D1 = 10, E1 = 20 and F1 = 10 Using the function SUM in the cell A4 = SUM(A1:C1) I have as a result 120 If I copy the cell A4 to B4 my SUM function will be B1 = SUM(B1:D1) and the result 80. I would like to know how can I copy the SUM function from Cell A4 to B4 but the SUM function should be SUM(D1:F1). And if a still copying to left side, I mean to columns C, D, E... It should set the SUM functional to jump in each 4 Columns. A4 = SUM(A1:C1), B4 should be sum D1:F1, C4 should be sum G1:I1 ... Regard...

Search within a part of a column
Hello! I got a small question, which should not be any problem for a Excel specialist. I want to search through a part of a column (i.e. "E200:E250") for a specific text (i.e. "P"), and if in one cell of the specified range exactly this text is found, I want to set a seperate text (i.e. "B") in another cell (i.e. "E255). Has anyone of you some idea for me? I tried like =if(E200:E250="P"; "B"; ""), but is not working! Best regards, Peter -- OBIPEDA ------------------------------------------------------------------------ O...

gray column
On occasion I get what feels like a crash -- in the middle of an excel session after a refresh or something I will get a 2-3 inch column of gray on the left side of my excel workbook. I can still move around, save, use the functionality, etc. but there is this gray area I can't see through. This view will remain even if I go to any workbook I have opened in this session of excel -- so its not a workbook problem per se. The only way to get rid of it is to go in and out of excel. Has anyone seen this or know what it is? Thanks, Jon In the absence of other replies ........ th...

Can you put white space outside a textbox?
When I put pictures in my publisher file, sometimes I want captions for the pictures. So I make a tiny textbox that I put under the picture, and type in a caption into that textbox. The problem is that I can make the picture have some space to left and right of it so that text doesn't crowd into the picture, but I can't do that with the textbox containing the caption. Is there any way to prevent outside text from crowding the borders of a textbox? You can move that textbox wherever you need. You don't need to leave space inside when you can steer clear of the textbox itself. ...

Relative references to named range
On behalf of my newphew, I received this query: "Quick one - I have a spreadsheet with very long formulas that reference a whole lot of variables in the same column. I tried naming the cells so that writing of the formula is easier to do. However, I need to copy the column across for other entities of varying nature, and these copied cells refer to the same named cell. Can I name a cell and copy it sideways so that it retains some sort of name with allusion to the column that it is in? Andrew van Gruting" I have tried copying a formula with a named range and, as expected, it maint...

ID inquiry about numbers in column A
Hi, I have 6000 id numbers in column A and I have had to delete some rows due to duplication. This now means those numbers which were in order 1 to 6000 now have numbers missing. How can I patch them up so that they are once again flowing from 1 to whatever. Thanks rock See other post. -- __________________________________ HTH Bob "rock" <1940@pobox.com> wrote in message news:uNXC%234iIKHA.1020@TK2MSFTNGP02.phx.gbl... > Hi, > > I have 6000 id numbers in column A and I have had to delete some rows due > to duplication. > > This now means those n...

VB script help to find columns and change...
Ok, I have 4 columns: Department, Date, Employee Name, Daily HR attendance code so A, B, C, D Headers are on row 1, everything below that is data... So what I wanted to be able to do, is change the HR code with a script, incase managers make a mistake. So, first first the Date from B, then in Offset find the right name to match the date, and then if those two match change the HR code using offset on the same row. starts here ------------- Sub changedhrcode() Dim lastrow As Long Dim cell As Range Dim txtDate As Date Dim txtName As String Dim txtHR As String lastrow = Range("B6553...

How do I make column C a percentage of column B
I need to calculate different percentages for fixed numbers I have in column B. How do I make column C a percentage of B, column D a different percentage of B, and so on. Hi, not pretty sure what you want, you need column C to show percentage of B based on a column B total ? if yes do =B1$B$100 B100 = cell with the total dopy formula down if this is not what you were looking for please give an example thanks "dbcruzin" wrote: > I need to calculate different percentages for fixed numbers I have in column > B. How do I make column C a percentage of B,...

Save record order in main table
Hi, I have a form which displays four field from a table. On the form I have 4 sort buttons which sorts the form based on the field selected. My table also has a field for a sequence number. Based on the sort order selected I would like the sequence number field for each record in the table to correspond to the record number shown on the form. In other words, based on the sort the first record shown on the form would get a sequence number of 1 in the table, the second record shown would get a 2, etc. Is this possible and if so could someone help with the code. Your help woul...

Where to put SQL statements in VC++ Application
I am wondering if putting all my SQL statements in the string table is a good idea. Is there a better place to store these statements?? Thanks in advance for any responses. Dominic Inline in the code, they arnt particually helpful to put in the string table. -- - Mark Randall http://zetech.swehli.com "Those people that think they know everything are a great annoyance to those of us who do" Isaac Asimov <dominicgualtieri@hotmail.com> wrote in message news:1129050897.519688.176820@g49g2000cwa.googlegroups.com... >I am wondering if putting all my SQL statements in...

Multiple Columns in a stacked column chart
Is it possible to create multiple columns of stacked data sets? For example: can I plot monthly data in which each month is the sum of 3 categories, but plot these stacked columns for 2 years (side by side per month)? This enables me to compare last years monthly totals versus this years monthly totals on a per month basis? Justin - Through careful arrangement of the data in your worksheet, you can make a stacked column chart that looks like a clustered-stacked column chart. There is a tutorial showing this technique on Bernard Liengme's site: http://www.stfx.ca/people/blie...

Can't change a cell name back
I had a cell named "MP2OZ". It was supposed to be "ML2OZ" for milliliters to ounces. When I noticed the typo, I selected the cell, then clicked in the Name Box, and typed the correct name. As soon as I did it, I realized that this would not change the formulas that use that name. So, I changed it back (to MP2OZ) and then opened up the Name Manager (Ctrl+F3) and tried to change MP2OZ to ML2OZ. The Name Manager says that both the old and new names are already in use and to choose a different name. But the Name Manager only shows the one name (MP2OZ). It does not show ML2OZ....

Unwanted change in width of columns when showing formula.
When selecting to show formulas in cells, a lot of my columns change their width. I have confirmed that I am viewing the worksheet at the same zoom-level before and after switching to showing formulas. When reverting back to show the actual results of the formulas in the cells, the width also goes back to what I had initially decided on. Why is this (width gets bigger)? I want to have the freedom to maintain _my_ chosen column-width, stupid-looking as it might be. Is there a solution to not have the column-width changing like this? Thank you in advance. The column widths change because E...

Comparing 3 columns?
How do I compare a value in one cell, to a value in a column, that looks at the value in the adjacent column, to display in a cell? For example: cell A1 = cindy; column B in cell B17 = cindy; and in the adjacent cell, column C17 = 777. I would like the value of cell C17 to display in a cell. Does anyone know how to do this? =VLOOKUP(A1,B:C,2,FALSE) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "cthompson17" wrote: > How do I compare a value in one cell, to a value in a column, that looks at ...

column labels repeat in excel
how do I make the column labels repeat in a spreadsheet? When I follow the help directions, I am unable to "enter the row numbers" I keep getting a message that it is an invalid entry. What am I doing wrong? Try this, Karen: http://www.officearticles.com/excel/repeat_rows_at_top_when_printing_in_microsoft_excel.htm ************ Anne Troy www.OfficeArticles.com "Karen" <Karen@discussions.microsoft.com> wrote in message news:8DB073EA-440A-4EF8-8B64-82EC94F68E6E@microsoft.com... > how do I make the column labels repeat in a spreadsheet? When I follow > the...

How to Search two column value are match
Hi All I have two excel worksheet One is Updated by local user , A worksheet One is Updated by global user. B WorkSheet When A worksheet completed, the Upload to B worksheet. How to check two column value are matched by single Find command ? Provide the ID and Item are matched. Sub UPDATE() Const GPD_RBO_COL = 2 Const GPD_ID_ADD = 5 Const GPD_ITEM_ADD = 4 Const GPD_DT_FMD_COMP_ADD = 10 Const GPD_STATUS = 19 '~~ For Master Workbook Const GP_Sheet = "Digital Item Conversion 012709r" Const GP_RBO_COL = 1 ' Update Field Const GP_ID_RANGE = "V:V&...

Put app and icon in task bar?
I have an MFC application that I want to be able to put in the task bar as a small icon and have it pop up the dialog when selected from the task bar. This app is intended to be run from the start up menu and be minimized in the task bar along with all the other start items... Pointers on how to please... By default app goes on the task bar. Do you mean system tray (that by default appears on the bottom right of the screen)? -- Ajay Kalra [MVP - VC++] ajaykalra@yahoo.com "ShipHead" <GoAway@SpamBoy.com> wrote in message news:#g1K8UgEFHA.2700@TK2MSFTNGP14.phx.gbl... > I...

How to avoid name conflicts while copying sheets
hi, Hi i'm writing macros for an excel file. i've a macro which will read the data from there are 30 to 40 work books each work book contains 8 worksheets and copies that data and paste the copied data into new workbook with corresponding 8 sheets. it is copying the data into new work sheet. whats my problem is while coping the data from all work books data it gives an dailog box.it gives an error it shows the message as. i used same name in all 30-40 workbooks _DATA_impact_image "A formula or sheet you want to move or copy contains the name '_DATA_impact_image&...

Title Column
Hi all. simple question.... how would i go about making column A title column so when i move along, say to column z i can still see th titles in column A. :confused -- jhome ----------------------------------------------------------------------- jhomer's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2397 View this thread: http://www.excelforum.com/showthread.php?threadid=37596 Select column B Window>Freeze panes Does that help? Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: htt...

columns show as numbers
I just noticed that all of my columns now show up as numbers instead of letters, which makes it difficult for entering formulas - how do I get the columns back to letters Tools, Options, General, (uncheck) R1C1 reference style --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "jbv" <anonymous@discussions.microsoft.com> wrote in message news:B43F64D5-7296-43AB-A137-98F623BC5236@microsoft.com... > I just noticed tha...