How do I correctly sort a list of zip codes that has both 5-digit.
How do I correctly sort a list of zip codes that has both 5-digit zip codes
and nine-digit zip+4 codes?
Assume the zip codes populate cells A1:A100.
Use a helper column, say column B. In B1 enter the formula
and copy down to B100. Then sort A1:B100 by Column B and then Column A.
"firstname.lastname@example.org" <email@example.com@discussions.microsoft.com> wrote
in message news:B41E9C09-972F-443D-AF0A-64927EA797CB@microsoft.com...
> How do I correctly sort a list of zip codes that has both 5-digit zip
> and nine...How to print one header over several columns of data
I want to print one title over a span of columns - what is the command?
Format>Cells>Aligment>Horizontal>Center across selection?
Gord Dibben MS Excel MVP
On Thu, 27 May 2010 14:19:00 -0700, column title print <column title
>I want to print one title over a span of columns - what is the command?
...How to count rows with changing data
I have an imported list on sheet2 and it is maybe 100 rows. Each day the
data is imported the dates change along with the type of record associated
with each date.
Say this week there are 25 rows with 11/13, 20 rows with 11/14 and 25 rows
with 11/15 and 30 rows with 11/16. Mixed in with this each of these dates
might have a different type of record (each type has 4 options.)
I need to be able to do the following:
1.) I need to count the number of occurrences for each date and not only
show the total count but also show the date that is counted as the label.
2.)count the...populating tree view and list view
Hi, how do i populate a tree view to show all the drives on a system and how
to display the corresponding files and folders in a list view (ex.:
Thanx in advance.
"Kapil Patry" <firstname.lastname@example.org> wrote in message
> Hi, how do i populate a tree view to show all the drives on a system and
> to display the corresponding files and folders in a list view (ex.:
> Thanx in advance.
This is some old code I have laying around. I was just learning C++ so it
needs som...sort #5
I know how to use the sort feature in excel XP and have a macro to sort data
but is there anyway I can sort the data using a button/hyperlink/cell on the
As an aside, does anyone know why I can't see the posts I make to the group
but I can see all the replies?
Just drag a button from the forms toolbar onto the worksheet and assign your
macro to it.
Don't know the answer to the second I am afraid.
(remove nothere from the email address if mailing direct)
"elwyn" <email@example.com> wrote in message
Hello! I'm not sure if this is the right Excel group to post this question
in, but I am hopeful that someone can point me in the right direction:
I have a worksheet where all the rows represent tasks and the columns are
named "Requirements", "Build", "Test", "Deploy". The intersection of the
rows and columns have a numeric value (hours).
I would like to move this data into a separate worksheet where there is a
row for each task, but where the columns from the original worksheet
("Requirements", "Design", "Build&quo...rotating email recipients in list
Is there a way to setup a distribution list or some other
group that the users will be in a rotation to receive the
email sent to the group?? We use exchange 5.5 on a 2k box...visitors to
our website would fill out a form that is then emailed to a
distrobution list name. In this distrobution list are three emails.
Each time the form is filled out and sent it would send to one of the
emails on the list (this would rotate or cycle each time the form is
filled out)...is this possible?...thanks David
There is not builtin functionality to do this. You would need to write a
custom event sink.
-- ...show items with no data option in pivot tables
Can anyone help with some bizarre results I'm experiencing with the show
items with no values check box in the field settings menu for pivot tables.
It appears to be showing field headers that don't exist in my data????
I'm using Excel 2000.
Debra Dalgleish has some techniques at:
In fact, she has an addin that you may like:
> Can anyone help with some bizarre results I'm experiencing with the show
> items with no values check box in the field setting...Changing lowercase to uppercase in the Contacts list index
I am a vision impaired user who has often thought that it would be helpful to
be able to see the alphabet that is vertically placed at the right side of
the address book display.
I have never been able to find a way to change this display and have
concluded that I am stuck with the lower case letters.
Anyone know of a way to change this setting?
It can't be changed.
There is at least one tool that adds an index - not sure if it would help
you though - see http://alphabet.4team.biz/
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.n...Need 2 rows to display X axis data points for a line graph
X axis is 100 data points, and all must be displayed. They do display, but
are all mushed up. In Corel, you have the option to display the X axis on up
to 3 rows, with interspersed tick marks. In Excel, I seem to be able only to
manipulate the number of categories between tick marks and tick mark labels,
but can't stagger data onto multiple rows. Any ideas or add-ins I could try?
Excel 2002. Thanks, Susan
This web page gives a suggestion for staggering your labels:
Jon Peltier, Microsoft Excel MVP
Peltier Technic...VBA and researching data thru 20.000 records
I have 2 sheets with several fields.
on sheet1, i have new data and on sheet2 i have old data.
i would like to update 2 fields of sheet1 with data from sheet2.
for that i want to compare 3 fields, let's say C, D, E.
if C, D, E are equal on sheet1 and sheet2, so i want to copy data from
fields A and B (from sheet2) to fields A and B of sheet1.
for now i use selection.autofilter .....
on the 3 fields to compare, but with my 20,000 records, it's really slow
(on 3.1 Ghz CPU and 1 Ghz ram).
So i would like to know if exists another way how to do it and for sure
thanka ...Data validation 07-26-07
I am seeking to apply form level validation for two controls in the
before update event of my form. My code looks like this:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim strMsg As String
' An error that is special cased.
Const conErrDoCmdCancelled = 2501
On Error GoTo Err_BeforeUpdate
If IsNull(Me.cboMedium) Then
Cancel = True
strMsg = strMsg & "Medium required." & vbCrLf
If IsNull(Me.cboSubject) Then
Cancel = True
strMsg = strMsg & "Subject required." & vbCrLf
If Can...Make a Macro Button Look the way I want it to, not from the list
I have just gotten 2007, in the past I have set up Macro buttons for printing
to different trays, for Tray 1 I made the Macro button look like the number
1, Tray 2 Macro button looked like the number 2 and Stack Bypass Macro Button
had SB on it. I have managed to set up the macro buttons but I can't figure
out how to customize the bottons to look how I want them to look as in not
from the range made available at the time of recording the macro.
http://gregmaxey.mvps....XP vs Win 7 Contact List
Is there a way to export from XP and import into Win 7 the contacts list?
Win7 does not have a built-in e-mail client. Which one are you planning on
Imperial Beach, CA
"John Hooton" <firstname.lastname@example.org> wrote in message
> Is there a way to export from XP and import into Win 7 the contacts
...Data Validation #3
Hi, How can i prevent duplicate of data in a coloumn using data validation
Regards Ron de Bruin
"Mohamed" <Mohamed@discussions.microsoft.com> wrote in message news:3E0FD4D8-923D-4DBC-A1FC-D89792B5BFB8@microsoft.com...
> Hi, How can i prevent duplicate of data in a coloumn using data validation
for full details on how to do this.
"Mohamed" <Mohamed@discussions.microsoft.com> wrote in mes...Display Data Table in chart but don't show plot area
I am using Excel 2003. I have created some charts/graphs with data tables,
chart titles, etc. My customer only wants to see the data table and chart
title for each graph. Is there a way to turn off the plot area and change the
size of the chart so that the chart title is close to the data table?
But the data table merely reflects what is in the cells used to make the
Why not just display that data in a new format?
Or am I missing something?
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"RW" <RW@discussi...Clearing recently used list?
I created a test money file just so I can play around with it. I deleted
the file now but it still shows up in the recently used list under the File
menu. How do I go about removing it?
In microsoft.public.money, KcN wrote:
>I created a test money file just so I can play around with it. I deleted
>the file now but it still shows up in the recently used list under the File
>menu. How do I go about removing it?
You would have to search it out in the registry.
What am I looking for? I searched for "test" since that's what I named my
file... also ...To Do List
On the right of my screen is the to do Bar and at the bottom where my to do
list is supposed to be it shows the following: 'The Operation failed. An
object could not be found'..any idea what the problem is and how I can fix
BTW I'm using Vista (although it worked previously so that should not be the
Hope someone can help........ Simon :-)
Corrupted mail profile now fixed.
"SiG226" <email@example.com> wrote in message
> On the right of m...How to clear junk senders list???
How do I clear all the items in a junk email senders list?
I recently changed emails and there are so many in the old file, it
it totally unmanageable.
Is there a .txt file somewhere?
Thanks in advance.
Remove the "FOUR YOU" in my email to reply.
Yes, look for Junk Senders.txt on your hard drive.
Ben M. Schorr, OneNote-MVP
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"CR" <4Uwebhound2002@hotmail.com> wrote in message...Application Data redirection
I have a policy set to redirect users desktop and application data
folders to a share. The test computer is windows XP running Office
2003. The odd thing is the folders are different on the servers vs
what's on the local desktop. The server and desktop also have
different files in the \Application Data\Microsoft\Outlook folder,
which stores the users archive.pst file.\
The server has the following 2 files in the redirected folder
Default Outlook Profile.xml
Default Outlook Profile.srs
The desktop has these files
Is this behavior by default? Is there a way...VB.net
Hi, I am trying to update a field in a record of a Access Database
(whose structure I can not modify).
I got this error (translated from italian): "Data types do not match
in the expression" = "Tipi di dati non corrispondenti nell'espressione
The code is the following: (myField is a binary field as on Access
'determine new value
Dim newValue() As Byte = ... (valid data)
'write new attributes
Dim conn As OleDbConnection = myObj.getConnection
Dim cmd As OleDbComman...combining data from two columns into one
Column A Column B Column C
FirstName MI LastName
Need to combine data in column A and B to make C. Can anyone help me?
Use a formula like:
"eintpc5146" <firstname.lastname@example.org> wrote in message
> Column A Column B Column C
> FirstName MI LastName
> FirstName.LastName@XX...Cached Outlook address list to Contacts folder?
Is there an easy way to copy addresses from the Outlook address cache to a
How to automatically add recipient email address to contacts folder when
you mean the autocomplete cache? either an addin to add people you reply to
(http://www.slipstick.com/addins/contacts.htm#data) to contacts, or use
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http:/...Formulae extracting data from other spreadsheets
I would like to write a formula to extract data from a series of workbooks
whose filenames vary by month ie datajan05.xls, datafeb05.xls, etc.
I would like to write the formual so it copies the month from the top of the
column to create the file name ie =data[a1].xls . This would enable me then
to copy across the page rather than having to edit every cell formula.
Can anyone help? Thanks.
have a look in help index for INDIRECT
"David Clark" <DavidClark@discussions.microsoft.com> wrote in message
news:5BF8D6C3-96E2-4B...Unable to see new user accounts in Global Address List
We're running Exchange 2007 and Outlook 2003. I'm able to create a new user
account and send mail to the new address. However, the Outlook clients do not
see the new user listed under the Global Address List. Therefore, the "Check
Names" button doesn't work, and neither does sending to just the alias (w/o
@domain.com). Again, emailing to the full email address does work.
Is there something that needs to be set on the Exchange or Outlook side?
running Outlook in cached mode?
Susan Conkey [MVP]