Question about Business & Productivity Software

1 Answer

Sorting within a column

I have a list of names in a column with the first name, middle name, then last name - all in the same column. I know there is a way to change it so the last name is first, but I can't remember how.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that gotĀ 5 achievements.


    An expert who has written 50 answers of more than 400 characters.


    An expert whose answer gotĀ voted for 20 times.

  • Expert
  • 167 Answers
Re: Sorting within a column

This page covers how to manipulate columns when the data is formatted as "LastName, FirstName MiddleName"... I'm guessing you could just tweak it:

This google group goes more in depth on the topic:

Posted on Jan 04, 2008

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Sum numbers in a column down until you come to a blank, then start again

Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

1 Answer

What is the last column name of excel

I think there's no specific name for that column, but we can say it's A1048576.

May 29, 2010 | Microsoft Office Professional 2007 Full...

1 Answer

When creating a new email in Outlook 2007, if I click on the "To" button to pull up an address from my Contacts they are alphabetized by First Name. How can I get them listed by Last Name?

To setup up contacts by the person's last name. In Outlook, when you compose a new message, and then click the To or Ccbutton, the Contacts list may display names that are sorted by the contact's first name. Here's how you can change the list to display entries by the contact's last name.
Sort the Contacts list by the File As field
  1. Start Outlook.
  2. On the Tools menu, click E-mail accounts.
  3. Click View or change existing directories or address books, and then click Next.
  4. Click Outlook Address Book, and then click Change.
  5. Under Outlook Address Books, click Contacts: Mailbox -YourMailboxName, and then under Show names by, click File As (Smith, John).
  6. Click Close, and then click Finish.
Verify that the newly created contacts are filed in last name, first name order
  1. On the Tools menu, click Options.
  2. Click the Preferences tab, and then click Contact Options.
  3. In the Default "File As" order list, click Last, First.
  4. Click OK twice.
  5. To view the new Contacts list sort order, restart Outlook.
NOTE If you want to display a particular contact in a different order than the rest of the Contact list, you can modify the File As field in individual contact cards. For example, you may want to sort some contacts by the Company field.

Feb 08, 2010 | Microsoft Office Professional 2007 Full...

3 Answers

I am trying to install QuickBooks Pro 2007 on a new computer that has Windows Vista Business with SP1, and I had updated Windows, then installed QB but when I imported the company file, QB gave me a...

Why is this happening This issue can occur as a result of uninstalling the Google Desktop installed by Quickbooks on a computer running Microsoft Windows Vista. Launching QuickBooks after uninstalling Google will cause the error message.

Note: This issue is also known to occur with computers that have been upgraded from Windows XP to Windows Vista, where Google Desktop was uninstalled under Windows XP. Both cases would yield the same error message.
How to fix the problem This issue was resolved in the latest release for your version of QuickBooks.
Detailed Instructions Please update your program to the most current release.

just click on that link above then click on the 909ffb0.jpg(update) image on that page.

Oct 27, 2009 | Intuit QuickBooks Pro 2007 Full Version...

1 Answer

Excel lookup - match index array

The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.
Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.
Upper key plus symbol displays:
Right plus symbol on number pad displays:
[Shift] Right plus symbol on number pad displays:
[Alt] [4] [3] displays:
slash/slash/plus displays: //
slash/plus/slash displays: / /
Plus Plus Plus displays:
upper Plus Plus Plus displays:
Shift Right plus plus plus displays:

end of plus test.. thanks.

Dec 09, 2008 | Microsoft Excel for PC

1 Answer

If function in exel

For Current Date - you can use the =Now() function in your cell where you want the date.

For Contract #, I don't know what you're using, but you can link to a database of contract #s (see below), or you can name a range like current contract #, which gets updated by 1 each time you add another contract, which then is automatically posted on your EXCEL

Database is the range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
Field indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
Criteria is the range of cells that contains the conditions that you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Jul 15, 2008 | Microsoft Excel for PC

1 Answer


If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.
To do this, do the following:
1) Move the C Column to be the A Column, shifting all other columns to the right.
2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)
3) Use A1 as your search field.
4) In A2, enter the following formula:

Describing above parameters, in the formula:
$A$1 -> the search field (name your looking for).
$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.
3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.
Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

1 Answer


try using the formula "sumif". It allows you to sum by category/name. Good luck! D.

Sep 12, 2007 | Microsoft Office Standard for PC

1 Answer


Hi Ralph, On the first table If the name is in column A and dept is in B. Suppose the new names are in column D here's the formula =vlookup(D1,A:B,2,0) Note a few things - 1. You will only receive the 1st departament. 2. In case that the name in D doesn't appear in A you'll get N/A. This can be solved using the following formula: =if(type(vlookup(D1,A:B,2,0))=16,"",vlookup(D1,A:B,2,0)) Let me know if there's anything else. D.

Aug 27, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Business & Productivity Software Logo

Related Topics:

58 people viewed this question

Ask a Question

Usually answered in minutes!

Top Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18258 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides