Sorting #7

I am trying to sort column
1-C-2
5-B-1
10-A-6
How can I sort and get 1-C-2 to show before 10-A-6. 10 is sorting ahead
of 1
Thanks
joey :rolleyes:  :rolleyes:


-- 
joey5
------------------------------------------------------------------------
joey5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25541
View this thread: http://www.excelforum.com/showthread.php?threadid=389770

0
7/25/2005 1:02:33 AM
excel 39879 articles. 2 followers. Follow

3 Replies
472 Views

Similar Articles

[PageSpeed] 49

I'd insert 3 additional columns to the right of that column.

Then select your column and do:
data|text to columns
choose delimited (by dash)
and plop it into those 3 new columns.

Then select your entire range and sort on those three "helper" columns.

Delete them when you're done (if you want).



joey5 wrote:
> 
> I am trying to sort column
> 1-C-2
> 5-B-1
> 10-A-6
> How can I sort and get 1-C-2 to show before 10-A-6. 10 is sorting ahead
> of 1
> Thanks
> joey :rolleyes:  :rolleyes:
> 
> --
> joey5
> ------------------------------------------------------------------------
> joey5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25541
> View this thread: http://www.excelforum.com/showthread.php?threadid=389770

-- 

Dave Peterson
0
petersod (12005)
7/25/2005 2:33:51 AM
Be careful, Text to Columns destroys the original data so copy column A to
column B first, and split that column.

-- 

HTH

RP
(remove nothere from the email address if mailing direct)


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:42E44F8F.ECF15A58@verizonXSPAM.net...
> I'd insert 3 additional columns to the right of that column.
>
> Then select your column and do:
> data|text to columns
> choose delimited (by dash)
> and plop it into those 3 new columns.
>
> Then select your entire range and sort on those three "helper" columns.
>
> Delete them when you're done (if you want).
>
>
>
> joey5 wrote:
> >
> > I am trying to sort column
> > 1-C-2
> > 5-B-1
> > 10-A-6
> > How can I sort and get 1-C-2 to show before 10-A-6. 10 is sorting ahead
> > of 1
> > Thanks
> > joey :rolleyes:  :rolleyes:
> >
> > --
> > joey5
> > ------------------------------------------------------------------------
> > joey5's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=25541
> > View this thread:
http://www.excelforum.com/showthread.php?threadid=389770
>
> -- 
>
> Dave Peterson


0
bob.phillips1 (6510)
7/25/2005 8:21:58 AM
There's an option on the Step 3 (of 3) to specify the destination cell so that
you can avoid overwriting that existing data.

(Heck, it doesn't have to even be adjacent to the original data--I just like to
put it there so I can see it easily.)

Bob Phillips wrote:
> 
> Be careful, Text to Columns destroys the original data so copy column A to
> column B first, and split that column.
> 
> --
> 
> HTH
> 
> RP
> (remove nothere from the email address if mailing direct)
> 
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:42E44F8F.ECF15A58@verizonXSPAM.net...
> > I'd insert 3 additional columns to the right of that column.
> >
> > Then select your column and do:
> > data|text to columns
> > choose delimited (by dash)
> > and plop it into those 3 new columns.
> >
> > Then select your entire range and sort on those three "helper" columns.
> >
> > Delete them when you're done (if you want).
> >
> >
> >
> > joey5 wrote:
> > >
> > > I am trying to sort column
> > > 1-C-2
> > > 5-B-1
> > > 10-A-6
> > > How can I sort and get 1-C-2 to show before 10-A-6. 10 is sorting ahead
> > > of 1
> > > Thanks
> > > joey :rolleyes:  :rolleyes:
> > >
> > > --
> > > joey5
> > > ------------------------------------------------------------------------
> > > joey5's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=25541
> > > View this thread:
> http://www.excelforum.com/showthread.php?threadid=389770
> >
> > --
> >
> > Dave Peterson

-- 

Dave Peterson
0
petersod (12005)
7/25/2005 11:45:16 AM
Reply:

Similar Artilces:

Exchange Delivery Delay (Error 4.4.7)
We recently installed SBS 2003 and are using Exchange 2003 for email. Everyone can log in and use exchange with no problems. All seems to be working ok. But some of the users are getting Non Delivery Reports. On some email messages. The reports are in the following formats: This is an automatically generated Delivery Status Notification. THIS IS A WARNING MESSAGE ONLY. YOU DO NOT NEED TO RESEND YOUR MESSAGE. Delivery to the following recipients has been delayed. carlos.caxias@dywid.pt Reporting-MTA: dns;maildywid.Dywid.co.uk Final-Recipient: rfc822;carlos.caxias@dywid.pt Action: d...

FRx 6.5 Reports with FRx 6.7 Report Server
Can FRx 6.5 reports work with FRx 6.7 Report Server without being upgraded to FRx 6.7? Any Help would be appreciated. ------=_NextPart_0001_2CE4EA95 Content-Type: text/plain Content-Transfer-Encoding: 7bit Hi Andrew, Thanks for the question about FRx 6.5 and 6.7. I would recommend having your entire FRx environment operating on the same version. When using different versions of FRx in one environment it can create problems. Let us know if you have any questions. David Treleaven Microsoft Online Partner Support When responding to posts, please "Reply to Group" via you...

OWA Question #7
Ok I am switching from OWA on Exchange 5.5 to OWA Exchange 2003. I got OWA to work correctly. I just have one question. Some of my Users have there Bookmarks pointing to https://servername/exchange/logon.asp But they get a 404 error pages doesn't exist. Where does Exchange 2003 look for this file so I can put a page redirect so they go to the correct address. Any help would be great. Thank you, Kyle Kyle D, In exchange 2003 with forms based authentication it would be Https://Server/Exchweb/bin/auth/owalogon.asp this points to (in a default install) C:\program files\ex...

Windows 7 Multi-touch driver capability discovery and reboot probl
Hi, I created a Windows 7 multi-touch HID driver based on WDK EloMT sample. The driver works ok but I have the following problems that I don't know how to fix them. 1. After my driver is installed (without reboot), sometimes the computer property shows "Touch Input Available with 2 Touch Points", sometimes it shows "No Pen or Touch Input is available for this display". 2. After my driver is installed, most of the time the system won't ask for reboot but sometimes it will. If anyone can point me the direction of how to solve these inconsistenci...

Windows 7 stuck in "Preparing to Hibernate"
How do I override "Preparing to Hibernate" or "Preparing to Shutdown" ? It's been in this mode for over six hours. Nothing removes the blue screen w/these words. Nothing to do with Word, but just keep the on/off switch pressed. -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "lsmo64081" <lsmo64081@discussions.microsoft.com> wrote in message news:61669E75-5C16-4D1B-B69A-89F293C9B0FF@microsoft.com... > How do I override "P...

Restore Backup from Outlook 2003 into Windows 7(64)
Old laptop running XP; did backup of Outlook 2003 pst files using microsoft personal folders backup tool, to ext. hard drive. Connected hard drive to new laptop running Win 7(64). How do i restore the bu? All attempts met with error message saying I do not have authorization to access the file. Then tried to export the pst files from old laptop to ext hard drive. Connected hard drive to new laptop and tried to import the exported files into Outlook 2003. Got a similar message saying I did not have permission to access the selected files. Please help Bill. Submitted using http:/...

Sorting problems with other worksheets!!!
I have a problem!!! First I have multiple worksheets in a workbook. And in one column that has some names. and the columns next to them has data which is yes/no go/ngo for each person. If I add a person it will update itself in each worksheet. But I need to sort it. So I sort it and it sorts fine in the worksheet I'm working in. But with the other worksheets it sorts it but the data for each person doesn't stay with the person... I hope I explained this problem to where someone can understand. PLEASE HELP!!! It used to happen when a column (in this example the one containing ...

Sorting Alpha-Numeric Values
I would like to sort data that have aplha numeric values. When I use the sort command, the numbers wind up getting sorted by place values instead of the actual value of the number, kind of like alphabeticaly except with numbers instead of letters. For instance, I would like to these numbers sorted like this: 17A 36B 265F 1492C 1609A Instead, Excel sorts them like this: 1492C 1609A 17A 265F 36B It appears that the suffixed alpha characters alter the way the numbers would normally be sorted. Any ideas how I can sort them more logically/numericaly? Thanks! Larry ...

excel sorting 03-28-10
I have a text spreadsheet of 5,000 names and addresses. Column B needs to restricted to only 16 characters in that column. How do I send the records to the bottom of the page (or delete them) that have data that exceeds 16 characters in Column B? You could insert a new column. In that column, in row 2 put the formula =len(B2) and copy it down the column. Then sort the table on then new column ascending. Tom ...

Sorting data with the letter 'E' included
I have a list of department codes that I need to sort. They are in the format number, letter, number, number. All end in zero; for example 2C00, 5D00, 2E10. In most cases the last two numbers are zeros. The problem is with the codes that contain the letter 'E'. I was originally having the problem of Excel seeing all codes containing the letter 'E' as numbers and putting them into scientific notation. I subsequently formatted them as text which fixed the display problem, but now when I sort, all the department codes that contain 'E' are sorting at the...

How to succesfully sort column of formulas?
I am trying to sort a column of formulas that consist of cel references. Example: Column: Cell 1 holds: =D10 Cell 2 holds: =D11 Cell 3 holds: =D12 Data: D10=1 D11=2 D12=3 When I try to sort the column of formulas, the formulas change cel references to other cells and mess up the data. How can I sort a column of cells of which all of them contain formula and have the cells keep the references to the right place -- Message posted from http://www.ExcelForum.com Hi- If you write your formulae with absolute references rather tha relative references, you can sort them. Formulae should look ...

WIN 7 and IE8
Hi, I have Windows 7 / 64. The computer came with Internet Explorer 8. All the previous Internet Explorer that I have had, when you are viewing and reading a page, you could go to File-- Send- and had the choice Send it by E-Mail or Send Link by e-mail. With Internet Explorer 8, if you go File-Send- the choices to Send Page by E-mail and Link by E-mail are grayed out. The only choice you have is to send Shortcut to the Desktop. My question is: how can I activate the 2 grayed out choices, so that I can send the page by e-mail? Thanks for any info. Doc Win 7 does not come ...

Gift Certificates #7
I have a question that is probably more of a workflow related question. We have an implementation of RMS that is configured to issue gift certificates and vouchers. My question is how they get counted from a sales perspective. Lets say you have a gift certificate for a $100. A customer comes in to redeem that gift certificate for a $100 item. I would expect total sales for both transactions to be $100, however, RMS shows that the total is $200. If anyone could validate if this is correct and the general phylosphy around it, that would be great. Thanks in advance .... I'm no expert, ...

Custom auto-sorting...possible?
Is there a way to have excel auto-sort (cutom) by criteria in 3 columns? I think it might be easier to explain by viewing the workbook http://poolgod.zftp.com/predictions.xls. The picture shows how I need it to sort. I found some information on auto-sort in help and also on the net, but I don't know how to incorporate the multiple criteria or if it's even possible. Any ideas? Thanks, Steve -- Pools ------------------------------------------------------------------------ Pools's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35961 View this thread: ht...

Stats microsoft.public.windowsxp.general (last 7 days) 06-07-10
"Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: microsoft.public.windowsxp.general Stats Were Taken..........: Mon, 07 Jun 2010 08:14:28 GMT Stats Begin...............: Mon, 31 May 2010 08:29:11 GMT Stats End.................: Mon, 07 Jun 2010 06:42:42 GMT Days......................: 7 Total No. of Articles.....: 526 Total No. of Characters...: 1263268 Total Volume..............: 1233 Messages Per Day..........: 75.1 Characters Per Day........: 180466.9 Average Daily Volume......: 176 kB Total Posters This Week...:...

Dynamic sorting of rows of data.
Hi, I have data in Column B thru V. Row no 1 is header row. Data extends till lets say row number Z where Z keeps on changing depending on the amount of data. For calculating the value of Z, I use the no of entries in column F as the basis ( as it could be possible that cell B59, C 59 has no data but F59 will have data) This Z is calculated within the VB code and designated as the variable "rowcount". Now comes the real ( and difficult part)... I want to sort the above data. I recorded the macro as per my sorting specifications and got the following code: Rows("2:" ...

Will my Office XP install on Windows 7?
I have Office XP. I need a new computer and need Outlook and Access on it. Will Office XP install on Windows 7? Yes it will, but Outlook will not retain account passwwords Office 2003 and later is fully compatible "glouces" <glouces@discussions.microsoft.com> wrote in message news:8699F413-1E85-4CC3-BD05-856A8ECC578B@microsoft.com... >I have Office XP. I need a new computer and need Outlook and Access on it. > Will Office XP install on Windows 7? ...

How do I autodate(excel) every 7 days ex. 1/1/06-1/31/06?
Enter 1/1/2006 in A1 In A2 enter =A1+7 Drag/copy down. Gord Dibben MS Excel MVP On Thu, 12 Jan 2006 11:36:03 -0800, "tlk1214" <tlk1214@discussions.microsoft.com> wrote: ...

Vlookup #7
Hello, I have a list where I am doing a look up from another sheet based on an employees ID number. The 2nd spread sheet is a listing of all the employee activites they did that day expressed through different codes. My question is how do I bring back all the information if using a vlookup only brings back the first match and some employees have multiple activity codes for that day. Is there a function out there to solve this problem? Thank you, Denise The easiest thing that comes to my mind is using PIVOT TABLES. In a column drag employee ID, in data you can have your code cou...

how do you sort a table by column 1
thank you in advance -- paul Hi Paul I am not too sure where you are in EXCEL or what you are asking but let me give you a simple example in the hope that it will answer your question. 1. Bring up a new (blank) Workbook. 2. In cells A1 to A5 enter:- a1 a2 a3 a4 a5 3. In cells B1 to B5 enter:- b1 b2 b3 b4 b5 4. In cells C1 to C5 enter:- c1 c2 c3 c4 c5 5. To sort by colum A (in EXCEL 2007):- - highlight A1 to C5 (inclusive) - Data / Sort / Sort by Column A / Order Z to A 6. Hit OK. 7. You will now see cells sorted as follows:- a5 b5 c5 a4 b4 c4 a3 b3 c3 a2 b2 c2 a1 b1 c...

OUTLOOK #7
a) I want all of my mail to vcome into my Outlook. A box keesp poping up asking for my user name and password. I am not sure which one to put in as I have more than one address. b)When I go to send it comes up. " Relaying temporarily denied. Cannot resolve PTR record fro 200.94.221.127 It has also said that an addres towhich I am sending may be forged. John Glaab john.glaab@settlement-co.com ...

SORTING question
Hi. I'm using MS XP (Home) and MS Excel 2003, and I'm just learning how to use the program, so please bear with me (what follows below is a little long-winded). I recently imported a very large Access database file into Excel. This file has five columns, and one of them is a KeyID column (numbering 1 to 60,000). I will be sorting this Excel Sheet frequently, but I need to maintain the exact (original) order of the file for reasons I won't go into here. I will sort the Sheet, make some changes, then sort on the KeyID column to return to the original order (which starts a...

Sorting to count
Reason Location BENT 1 POR 2 BENT 2 POR 1 BENT 1 I want to set a formula that will count only the location 1's that ar bent. Can anyone help?????????????????????:confused: ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com YOu can put in a new column with the following =if(and(a1=&...

Extremely slow open doc missing template
When we open a document with a template \\servername\folder and the server does not exist i e when opening a document attached in an email it takes about 5 minutes to open the document. The problem occours when working in a net work. If we replace the template path with normal.dot the document opens fast. But there are thounsands of documents. If I open the same document in Vista or in Server 2008 R2 I can press ESC to stop Word looking after the template. But it does not work in Windows 7. I am going to try this old solution .. think it is the same problem .. so maybe it ...

Great Plains 7.5 Budget
Curently, I we doing Budget in Excel and then import that in to Great Plains 7.5; Excel work is very time consuming and I would like to get it all done in Great Plains. I have been reviewing Budget module in GP and need some help. I was uanable to find a screen where I could enter a budget amount for a department and distribute it to different allocations; the following is a sample Excel Spreadsheet data from the main sheet: Account Description Overhead All Period 1 ...... 544-411000-000000-050-544 OFFICE EXPENSES $35,000 $2,916.67 544-411000-000000-100-544 OFFICE EXPENSES...