Sorting issue - Excel 2007

Hello,  I am having a problem sorting two columns (one is the street
name and the other is the street number eg. 321 Smith St) in Excel
2007 by using a custom sort.  Let's say that the data in column A is
the number and B is the street name.  I have the sort setup to sort
first by B then by A.  The problem is with the numbers.  Some numbers
are out of order in the spreadsheet although the majority are
correct.  I have formatted the number column (A) as a number as well.
I have also tried creating a new spreadsheet and pasting (paste
special) the data into it with the same result.  Can anyone help me
out on this one?
0
4/3/2009 8:54:47 PM
excel 39879 articles. 2 followers. Follow

0 Replies
593 Views

Similar Articles

[PageSpeed] 59

Reply:

Similar Artilces:

how to use Excel 2007 Sensitivity Analysis
could any help provide a sample excel worksheet with sensitivity analysis demo, including use of scenario manager to generate scenario summary. ...

Excel 07
I have a stacked chart with one series showing positive values, and two other series showing negative values. When I add data labels, they only appear on the positive value series. Even when I click on the negative series, I get the menu to format the data labels, but in no way, shape, or form are they actually visible on my chart. Any thoughts? Thanks! I used this data Group Alpha Beta A 1 -1 B 2 -4 C 3 -6 D 4 -4 E 5 -3 Made a stacked column chart Added data labels to each data series; both were visible Changed chart type to Line and to Bar and data labels remained visible What to se...

Help
Hi All, I'm posting out as I've been having some issues with 3 nearly identical clients ever since putting in SBS2008. They have proven very difficult to trace and resolve. Client 1 - SBS2008 new install, new domain etc on HPML110, 5 users Client 2 - SBS2008 migrated from SBS2003 via MS Migration on HPML150, 15 users with all new HP/WinXP workstations Client 3 - SBS2008 migrated from SBS2003 via Swing It! migration, on HP ML350G6, also about 15 users. All 3 have Sonicwall TZ series firewalls, HP gigabit switches, and use Windows XP and Office 2003. All use Exchange ...

Lists in excel
Is there a way to have a list that will eliminate a value once it is already used in a group of cells? Have a look here: http://www.contextures.on.ca/xlDataVal03.html -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Kameca" <Kameca@discussions.microsoft.com> wrote in message news:2B43DEBA-1BFD-457E-884C-6643C95081F1@microsoft.com... > Is there a way to have a list that will eliminate a value once it is > already > used in a group of cells? see: http://www.cpearson.com/excel/Duplicates.aspx -- Gary''s Stud...

Sorting a column by using formula #3
I am trying to use sort function just to delete blank cells in between Sort order doesn't matter actually. Data is coming by the use of simple cell reference of "another sheet -- Prais ----------------------------------------------------------------------- Praise's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1558 View this thread: http://www.excelforum.com/showthread.php?threadid=27144 Hi you may use the following addin to filter out blank cells: http://www.rondebruin.nl/easyfilter.htm -- Regards Frank Kabel Frankfurt, Germany Praise wrote: &g...

I need to C&P a section of Excel to Word but I need to get it to fit on a standard 8.5x11!
Is there a way to make this happen? The sections that I need to C&P are all the columns are 14 wide and the rows are 40, 41,44 and 65. How do I get these to fit on the page? Marc Marc wrote: > Is there a way to make this happen? The sections that I need to C&P are all > the columns are 14 wide and the rows are 40, 41,44 and 65. How do I get > these to fit on the page? > > Marc > > Smaller font, cut margins to the minimum, print landscape Print Preview > shrink to fit, are all options just depends on how wide the fields are. It just may be to big to fit ...

xlodbc.xla - Excel ODBC Add-In
Hi, I am trying to run SQL queries directly from a worksheet in Excel. I have found an add-in for Excel 2002 that is no longer supported in 2003 or 2007 which is just what I want (xlodbc.xla). 1. Why was this discontinued? 2. Is there a built-in way to do this in newer versions [running queries from a cell, NOT going to Data > Import > etc...]? 3 Any other thoughts, help, advice? Thanks! If you are looking to run a parameter query there are much better ways, You may find this helpful. http://www.nickhodge.co.uk/gui/datamenu/dataexamples/externaldataexamples.htm About 3/4 wa...

language issues outlook calendar
Hello, I've run today into two quite interesting issues. Users of OL2K3 are having the wrong language version in their calendar folder. For one user an upgrade from French to Spanish has taken place and now she has a French PLUS a Spanish calendar. Also I have a user who has simply Dutch instead of French. Do you have any idea where I can change the language settings in Outlook clients? Thanks for your comments. Sandor Teglasy Start Outlook with /resetfoldernames. Then transfer the data to a singular folder and remove the other one. -- Robert Sparnaaij [MVP-Outlook] www.howto-o...

Configuring Trend IMSS7.1 with Exchange 2007
Hi All, Its new setup Firewall: Fortigate 80C Server : Exchange 2007 (Mail Box , Hub transport & OWA) Server : Redhat Linux With Trend Micro Inter Scan Messaging Security Suite(7.1). i want to configure. Incoming Mails Flow chart : Firewall --> Trend Micro IMSS --> Exchange --> Users OWA has been Published with ISA2006. Intranet mails Working . Kindly help me to configure External mails sending and Receiving Kindly Help me how to configure the connective in between all the three. ...

Excel 2003 question about help menu
I use Excel 2003 OFF-LINE. I find myself extremely limited and frustrated with the "menu approach" that it uses as well as the set number of items it will display as the result of a keyword search. The main problem for me ATM is that I know that the functions are categorized into say eight categories, e.g., text, but I don't always remember all of them. In the past, a search in Help would return a list of those categories from which I could quickly and easily navigate around to doublecheck my understanding. Search results in Excel 2003 are erratic, and trying to find the list...

Outlook email templates
I have several templates in Outlook 2003. Will they work in 2007 as is, or will some tweaking need to be done? Thanks! ...

Excel Macro
Hi, I have a regular task that I do on a pivottable that looks like this (but longer): No Code Total 1 DN 841.92 PRP08 0 PRP30 0 2 RDB 0.00 RTQ 0.00 RVW 15,636.98 3 PRP42 3,435.76 Grand Total 672,328.19 I paste this info into a database which requires the number to be repeated on each line. At the moment I use a macro to copy the data down to the next entry as shown below starting in the cell that has No in: Selection.End(xlDown).Select Selection.End(xlDown).Select ActiveCell.Offset(-1, 0).Select Range(Selection, Selection.End(xlUp)).Select Selection.f...

Excel 2007 chart line types
Hi, When using Excel 2003, I was able to copy charts, and then paste them into CorelDraw as metafiles, ungroup these, and use the lines from the charts in my graphics. Since upgrading to Excel 2007, I am still able to do this, but the lines now appear to have a more complex format (the compund type is mentioned in the line properties dialog), made up of border and line types. On exporting to CoreDraw, these lines appear much less uniform than previously, changing thickness along the length of the line. Is there a workaround to allow me to plot chats with non-compund type lines as was po...

ACCESS 2007 RUNTIME 01-07-08
Hey!! First of all -sorry for my english. Acc 2007 RT is in english version. is there othere language version? if not, how to deploy databases to non-english clients?should i hadle all massages by myself? Tnx for answers and any sugesstions. On Mon, 7 Jan 2008 04:35:56 +0100, "robert" <robert774@o2.pl> wrote: You can create ribbons to replace the old menu system, and you can write them in the local language(s). For error handling, I would create a central error handler function, and in it you can display your own messages to replace the default English text. -Tom. >He...

Can't get bar code font to work in EXCEL 2003
I have a simple formula that converts a part number to a 3 of 9 bar code font in Excel 2003. Works great on my computer but a co-worker, who also has Excel 2003, can't get this to work. On her PC it show the 3 of 9 font in the drop down box but in the cell it is not converting it to a bar code image. Any suggestions? Thanks, Tony Most likely the font is not installed properly... She needs to reinstall the font. It can be done through Control Panel -> Fonts if you have the font available. "Tony" wrote: > I have a simple formula that conve...

Line Graph in Excel
I have created a line graph in Excel (with my input data on a separate worksheet). I have 3 columns: Planned, Actual, and New. I am tracking 'requirements' and I only want 2 lines on the graph. I have plotted the Planned and Actual, however I want the 'New' to be added to the 'Planned' in the graph. Maybe my example below will help? Planned Actual New A 10 8 0 B 15 12 2 C 20 17 0 D 25 23 ...

ADVANCE FILTER SORT WINDOW
Hi! Could anyone please help me? I have this continuous form called "frm_Status01" with a button that has this code "DoCmd.RunCommand acCmdAdvancedFilterSort" to open the advance filter sort window. After I have completed selecting all the fields I wanted, key in all the cretirea, sort, etc then click the apply filter button shown at the advance filter sort window and my "frm_Status01" is already displayed and active. The advance filter sort window didn't close after I applied the filter. Is there any way to close it immediately after I applied the...

Saving Issue in 2007
Hello, I created a PowerPoint 2007 presentation yesterday .pptx and saved it to my network drive. I'm the only person who worked on it. Today I opened the file and made revisions to it. When it's time to save the file, I went to Office Button > SAVE. I got an error saying the file is in READ-ONLY and cannot be saved. I have to rename the file. Does anyone know why this is happening? No one has the file open besides myself. This happened to me on Monday and yesterday. Any help or suggestions would be greatly appreciated. This will often happen if you'r...

repeating a data pattern in excel
Im using excel to run a class register for a playgroup. Each pupil is booked in for a number of days per week. To show their forecast for the year, I'm manually entering the days they're going to be present each week - is there a way to do this automatically? For example, Ben is booked in for Mondays, Wednesday and Fridays - how can I copy this weekly pattern throughout the year without manually tabbing across and ticking the relevant days? Hi, Kel. To do this manually, but easily, type the first 3 "sets". Select them all and copy down using the fill handle. You coul...

OWA Issue #10
Hi, I have a single user who is having issues with OWA not loading his mailbox. What happens is that his account appears to be accepted and OWA tries to load the mail screen but fails. I can reproduce this on several machines so I don't think it's related to his PC. The only odd thing I see with his account is that he has a ton of folders in his mailbox (not under his inbox but at the same level as the inbox). Is there any limitation to the number of folders a user can have? Any other ideas? Thanks, Dan On Mon, 1 May 2006 11:28:02 -0700, Dan <Dan@discussions.microsoft....

View Access 2007 using 2003 version
I know MS has a fix to open Excel, Word, and PP using Office 2003 that was created using the MS Office 2007 product. But do they have something to do the same for Access? I'm betting that a Access 2007 can be saved down to 2003 but I'd rather not do that. On Mon, 18 Feb 2008 12:13:04 -0800, TX - CAP <TXCAP@discussions.microsoft.com> wrote: No. But there is a free runtime version of Access 2007 that may suit your needs. http://www.microsoft.com/downloads/details.aspx?FamilyId=D9AE78D9-9DC6-4B38-9FA6-2C745A175AED&displaylang=en -Tom. >I know MS has a fix to open Ex...

Receiving email in outlook 2007
Trying to send/receive, send works fine but can not receive any emails. Receiving error 0x800ccc0f the connection to the server was interrepted. the server responded - ERR concurrent connections limit in avast exceeded (pass:20,processes:Rps.exe[20]), there is a collision with another program. I checked all settings and they seem fine. Anyone else getting this message or know what I should do. Thanks for you help. Mark wrote: > Trying to send/receive, send works fine but can not receive any emails. > Receiving error 0x800ccc0f the connection to the server was interr...

excel vba
i would like to bring up the file save as dialog box and defalut to a file type of xls.. here's what i'm using... 'i have a path and file name in Newfile NewFile = Application.GetSaveAsFilename(myfilename, "*.xls") thank you...! ** Posted via: http://www.ozgrid.com Excel Templates, Training, Add-ins & Business Software Galore! Free Excel Forum http://www.ozgrid.com/forum *** Hi try newFile = Application.GetSaveAsFilename(Initialfilename:=myfilename, _ fileFilter:="Excel Files (*.xls), *.xls") -- Regards Frank Kabel Frankfurt, Germany mjschukas wro...

2003 to 2007 graph editing
hello all: I am attempting migrate files from custom template in 2003 to similar template in 2007. I am running pp2007 with sp2. I have created a new potx and thmx file as well as several chart crtx files. When I open a ppt file and attempt to convert the graph files, I get hung up. If I use "edit existing" then of course ms graph pops up. If I choose "convert" then a new popup says "one or more charts in this document cannot be converted to the current Microsoft Office chart format". the process does not allow me to convert to excel based data she...

working with excel
i am using check boxs for yes and no questions,how do i simplify the size and centering them on a row and column? There are two different checkboxes--one from the controltoolbox toolbar and one from the forms toolbar. This code will fill the topleft cell with the checkbox: Option Explicit Sub testme1() Dim OLEObj As OLEObject Dim myCBX As CheckBox For Each OLEObj In ActiveSheet.OLEObjects If TypeOf OLEObj.Object Is MSForms.CheckBox Then With OLEObj .Top = .TopLeftCell.Top .Height = .TopLeftCell.Height .Wi...