Question about Computers & Internet

Open Question

Sort on multiple keys in QP

Need to sort on two columns in QP, for ex. Alphabet, and then by company so that I finish with a spreadsheet sorted alpha by company

Posted by on


6 Suggested Answers

  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

  • 450 Answers

SOURCE: Contact sort

Sorry, no can do. The only thing you can do is sync it with Outlook and use the sort options there.

Posted on Sep 12, 2005

  • 2 Answers


i have problem refference youtube port 80 ican,t watch youtube

Posted on Mar 04, 2009

  • 152 Answers

SOURCE: I have done something in

It sounds like the file is "read only". Open the file and save under a new name, or right click the file name and select properties. Then make sure the "Read only" box is cleared. The file could also be protected. Go to the review tab and sele "Ptotect Sheet" in the changes group. If the is no password, the sheet will be unprocted when you click the icon.

Posted on Mar 21, 2009

  • 1 Answer

SOURCE: Autofilter ceases to work on large Excel 2003 spreadsheet

Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Posted on Jun 18, 2009

SOURCE: sorting a single column with both first name and last name

are you using mssql then it must be something like this

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

Posted on Sep 27, 2009

Add Your Answer

Uploading: 0%


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



Related Questions:

1 Answer

What is a good numbering system for a customer job number

There are many ways of doing this and the complexity depends largely on whether you want the number to be generated sequentially and how you are going to record and interrogate the information. CRM software will usually have these functions built-in. (See Sugar CRM as one option)
For something much simpler you can manage in a spreadsheet, I like a system that can immediately identify the customer visually. For example "smith141008" identifies smith as having become a customer on that date (numbers entered in reverse for easier sorting). Or you can do it the other way around "141008smith) that make a sort easier by number. If there are multiple "smith" entries, try "141008smith-1 OR you can issue a unique customer code and record that.
If you have more than one product category, in Excel you can add a "key" column to indicate purchase history.

Oct 02, 2014 | Computers & Internet

1 Answer

I have a column containing a value of a single letter. I need the spreadsheet to sort add rows by letter.

Move the column to A. Mark entire sheet and sort ascending. There are more raffined ways to do this, but this is an easy quick fix...

Sep 07, 2014 | Microsoft Excel for PC

1 Answer

When using excel how to get dates to automaticly update in order

Sort the data to represent descending order for a chronological data set. If your information is listed in a table format in multiple columns, make sure you select all of the data and sort on the date field.

Feb 16, 2014 | Microsoft Excel Computers & Internet

1 Answer

Delete emails from certain contact

Generally you sort them in the order you want (to bring all the ones to be deleted together)
Select them all (left click the top one, Shift key + left click the bottom one)
Delete them

You may have to make more columns of data visible to get the right column to sort by

Nov 13, 2009 | AT&T Computers & Internet

1 Answer

When I try to merge my excel document with 250

Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.

Nov 09, 2009 | Microsoft Computers & Internet

2 Answers

Sorting a single column with both first name and last name

are you using mssql then it must be something like this

Select firstname + ' ' + 'lastname' as 'name' from tablename order by lastname

Sep 26, 2009 | Computers & Internet

1 Answer

Autofilter ceases to work on large Excel 2003 spreadsheet

Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Jun 16, 2009 | Microsoft Computers & Internet

1 Answer

Excel 2007 question

Ok, I realized that I wasn't paying attention when I created my test spreadsheet. My first cell wasn't sorting properly because it started with a ";" instead of a letter, so it always stayed at the top. I removed the extra character and repalced it with another letter, tried it again and it worked. If there's only 1 column, it doesn't ask to expand the selection. If there are nearby data cells, it asks you what you want to do. I was able to get it to work every time by selecting "Continue with existing selection" instead of "Expand selection".

May 14, 2009 | Microsoft Office Excel 2007

1 Answer

About formula

One way of finding (and removing) duplicate entries is to sort the column and put a simple formulate in a temporary column next to that column; for example - if column A has duplicates, insert a column (B) and starting in B2 put if(A2=A1,"DUP",""). Select B2 and scroll down to the bottom of your spreadsheet. Press <ctrl>-D to extend the formula in B2. Wherever there is a duplicate you'll see "DUP" in column B. If you want to remove the duplicates copy column B and Edit / Paste Special... with "values" selected (to wipe out the formula). You can then sort the spreadsheet on column B and remove rows with DUP in column B.

If you can't delete the duplicate rows and the order is important first include a column that captures the order - same trick except put row() in that column, copy / paste special the values and then you can re-sort after doing the above to have both the DUPs marked and the original order.

Hope that helps.

Aug 08, 2008 | Microsoft Computers & Internet

1 Answer

Sort data and create graphs for each quarter

you could have all the data in the same worksheet, but sort it using filters, eg click on the little arrow at the top of each column, then click on the item listed. this will then show only those rows associated with that item.

Jan 13, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

37 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers


Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides