Charting number of "name" occurences
:confused: Can someone tell me how I can chart the number of times a
name occurs in a column? I would really appreciate it. Maybe just like
a pie chart that everytime a new name is added it adds it in the chart,
and everytime a name is repeated it just adds to the count of the name
already added. Understand??? Can someone help me? Thank you!
silentop's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32271
View this thread: http://www.excelforum.com/showthread.php?threadi...naming shapes
how can i rename a shape?
rightclick the shape
and type your new name in the Name field
"mel" <email@example.com> wrote in message
> how can i rename a shape?
FYI: If another shape already has the name you type in, you'll get a
"dot-number" after your new name, but after you close the dialog.
So if there's a shape called "Decision", and you rename another shape to
Decision, it will end up named "Decision.36" or something si...New Domain name
We currently have the domain name format of dept.county.la.ca.us. We want
to change it dept.countyname.gov format. We also want to keep both domain
names for a certain period of time. What's the efficient way to do this? Do I
just add an alias to my exchang server? Do I need to assign different IP to
Assuming that all your users will get a new address with the new domain name
all you need to do is add the domain to the default recipient policy. If you
want it to apply to only a subset of your users a recipient policy might be
in order....failed to find host name from ip address
Please help a numpty in need!!
I have an account set up in outlook express 2003 which works fine.
I have now set up another account, and every time i send an email wifrom the
new account it comes back as undeliverable, with the following:
failed to find host name from ip address
Any ideas please??
"g00nor" <firstname.lastname@example.org> wrote in message
> Please help a numpty in need!!
> I have an account set up in outlook express 2003 which works fine.
> I have now set up another account, and every ...is there a "File name" function in ms Excel (2002)
Anyone know of any msExcel function that will
give the name of the current file?
To be honest I want if for printout purposes
because I am trying to avoid the custom header
etc (which seems difficult/impossible to format)
can be put in any cell
if you want the full path
=SUBSTITUTE(LEFT(CELL("filename",A1),FIND("]",...Is there a way I can split last name first name in one cell
I just got a list of customers we need to write about a new store opening.
However, I noticed that the first cell contained the last name of the
customer, then it has a comma, and then it has the first name. How can I
change that to last name in one cell and first name in another.I would of
course buy the program that will do that if there is no way to change that
w/o a special program. O yes yes, how about stripping the duplicates out of
the list, is there a way to do that as well. I'm an old guy, that used
excel for a while, but I can't remember anything anymore,
honestly......Ithaca Printer stops in the middle of last page
One problem I am trying to fix...
cash transaction has no problem no matter how many items are scanned.
when more than 2 items are scanned with credit card transaction; the last
page of the receipt stops in the middle.
so, printer prints 2 signature pages, 1 full page of receipt and 1 half page
any idea how to fix?
Hardware is Ithaca610 (Ithaca 280 Driver), win xp.
I am taking a guess as I have never worked with an Ithaca printer but try
checking the length of the page in the printer properties.
> One problem I am trying to fix...
> ...SBS BPA 2008: WARNING: DNS name server records do not exists
I get the following warning in SBS Best Practice Anaylser: "The DNS name
server records do not exists. The forward lookup zone DOMAIN.local does not
contain any DNS name server (NS) resource records with SERVER.DOMAIN.local
for the _msdcs delegation."
How can I fix this entry in dns-manager and what values do I have as
standard in this tree for an SBS 2008 Server?
Any help is greatly appreciated.
"Simon" <email@example.com> wrote in message =
> Hey everyon...How do I print only the first and last page of publication?
I need to print 500 11X17 sheets of only page 1 and 4 (first and last page)
KJL <KJL@discussions.microsoft.com> was very recently heard to utter:
> I need to print 500 11X17 sheets of only page 1 and 4 (first and last
Is this in a booklet format?
Go to Page 1
File > Print > Current Page > Copies: 500 > OK > Print as separate booklet:
Ed Bennett - MVP Microsoft Publisher
Print, current page, click "no". Try a sample first.
Mary Sauer MSFT MVP
"K...Local and Internet name...
I got a problem with a exchange 2003 SBS.
The domain name ( let say 123.org ) is by a provider , I configured pop3
connector to pik up email, this works fine.
As some 123.org users are in my lan and others around the country, I got a
problem when I try to send a mail to the users that are not configured in my
The exchange server server answer me that the user is unknown.
I heve certainely configured the server as as the FQDN 123.org name mail
name and this is my problem.
So my question is, can I change that and where.
Thank you very much for any help.
...Automatic divided by 100000
On a new worksheet, when I type in a number in the cell, right after I hit
"Enter", it automatic divide the number by 100,000, why this happened?
Tools>options>edit and uncheck fixed decimal places
> Hi all,
> On a new worksheet, when I type in a number in the cell, right after I hit
> "Enter", it automatic divide the number by 100,000, why this happened?
> Please help.
"Peo Sjoblom" wrote:
> Tools>..."how to delet names from Microtype"
I run an elementary school computer lab and cannot delete names from the
Microtype program that was installed previous to my employment. It is full
and I cannot add more names, Help!
This is a forum for Microsoft Word. I have never heard of Microtype, though
Google search results suggest that it is a typing program. From its Web
site, it does not appear that there are any user forums, but you can submit
a question via
http://www.microtype.swlearning.com/mt4/talktous/talktous.html. There is
technical support at
http://kb.cengage.com/display/Keyboarding/Keyboarding+Products, bu...Pub 2003 spaces last line ont paragraph differently
If you change the Line Spacing After Paragrahs from 0 to say 6pt Publisher
2003 increases the line spacing for the last line of the pagraph. So the
last line of the paragraph is a little bit further below the 2nd to last line
than all of the other lines are.
You can see this by creating a text box of XX's (2 paragraphs worth) and
changing the Spacing After paragraph.
Anyone know why this is or how to fix it?
Are you using a template?
"Mr. Analogy" <MrAnalogy@discussions.microsoft.com> wrote in message
Just downloaded Windows Live Mail 2011 beta, my current version now is
Version 2011 (Build 15.4.3002.0810)
This is a German version and i upgraded it from WLM.
First impression is quite ok - the import of all eMail accounts and store
As it seems the Alt+M shortcut no longer works, this displayed a familiar
drop-down menu style,
does anyone know if there is still a way to do this?
Next, if i understood correctly, the calendar still has no reminders,
unless you are logged into some live account.
Am i right or have i missed several things?
Ro...Print Comany Name on Report
Is it possible to print Company Name on the Reports?
Which report? Which version/edition of Money?
"Sameer Jaffer" <Sameer Jaffer@discussions.microsoft.com> wrote in message
> Is it possible to print Company Name on the Reports?
Money Small Business 2006. P&L or any report. When I see or print the report
My company name is not on it.. How to get that on the report.
"Dick Watson" wrote:
> Which report? Which version/edition of Money?
> "Sameer Jaffer" <Sameer Jaffer@dis...listing last & first names
i imported an access database, everything seemed to go
well. but it wont list the last & first names at all. not
even under "full name". im using the "detailed view"
under "full name, its blank. do i delete it? i couldnt
find a way to do that.
...Clearing Automatic Name Checking/Suggestion
Does anyone know how to clear the memory setting for automatic name
checking? When it suggests an email address, it gives me an old one
or incorrect one from my outlook that is no longer in my Contacts and
Please advise, I've already tried turning the settings on and off with
...make First row Header
How can I make the first row in my excel document the headers.
Example: change A, B, C to Name, Phone, Address
As I enter additional data I will need the forst row to stay as the header.
You can use letters or numbers or nothing.
Tools|options|General tab|check/uncheck R1C1 Reference style
tools|options|view tab|check/uncheck row and column headers.
But there's nothing stopping you from putting headers in row 1 and then freezing
panes so that row 1 is always visible.
As a user of excel, I expect to see the row and column headers. So I don't see
a problem...Dividing text
I know about the text-to-columns function, but if I have a sentence of
text with each word separated by a space, it'll split across as many
columns as there are words in the source cell.
If I want to split on a specific 3 character sequence (namely " - "), is
there any way I can do so by using the various text functions to
determine where in the sentence that exact sequence occurs, and
splitting only at that point?
Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)
As you may have discovered, the 'TextToC...Table Name
How do I get the name of the current table? I am talking about when I use
the Home>Format as Table (In the Styles section) and then format data as a
table. Typically Excel assigns the name Table1, Table2, etc. How can I
determine the table name in VBA?
here you go
Range(ActiveCell.CurrentRegion.Address), , xlYes).Name = "ABCD1"
But the only catch over here is your cursor should be with in the table.
I mean if you have data in range "A1:E40", then your cursor should be with
in this range. If the cursor is in cell...Name in email
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
Using EWS Entourage found name in the sent field is now email address by default rather than Office User name how can I change the sent by name to my name not my email address
Just to be clear when whoever I email receives and email from me it comes from my email address not my name like normal Entourage client does
On 2/2/10 3:18 PM, in article 59bb222b.-1@webcrossing.JaKIaxP2ac0,
"firstname.lastname@example.org" <email@example.com> wrote:
> Exchange Using EWS...Pivot
I have a pivot with Sales information. The data has multiple columns by
various product category. I have added a count column next to each
product column representing the dollar amount.
Is there a way in Pivot to get a calculated field of Total amount /
Count for each product to arrive at Average value per deal.
Excel does not allow me to use Calculated Item to get the average
Any suggestion is welcome.
If you are unable to create the formula in the pivot table, have yo
considered placing it in a row next to the table? Just a thought...
---------...Last Logon Time in Exch. Mgr./Mailboxes reset by scheduled mainten
I have been using Exchange Manager, via drilling down to the storage group's
Mailboxes screen, to get a check on users who are not active (and therefore
may have been excused without my knowledge). Recently, something changed
without intervention (probably via a patch) where the "Last Logon Time" is
being reset every morning at 2:30. I am assuming there is a maintenance
cycle involved, but I do not know what.
While I know there are utilities and scripts to mine AD for the needed info,
I am wondering what changed and if I really need this maintenance cycle? If
I cannot ...Excel Report Builder report is deleting the last column from SQL v
I am using Excel Reports in conjunction with Smartconnect. After about a
dozen smartconnect connections and refreshes of data from GP in my excel
report, the original SQL view created from the Excel Report Builder deletes
the last column from the SQL view.
I am now unable to refresh my excel report because of an "invalid column
The only work around at this point is to re-publish my excel report from the
excel report builder tool; however, this is not the preferred method of
Any other suggestions?
I just had this happened - I thought someone must h...Finding Last Record
Being very new to Access I am struggling a bit, so need some assistance.
I have an ACCESS 2000 manual and keep trying to figure it out, but I
am just a bit ACCESS deprived.
I have a form that will be used for New Employees. When I OPEN the
form, (OPEN event, I think,) I need to get to the last record in my
table. I have tried
DoCmd.GoToRecord acDataTable, "SalesAssociate", acLast
but get an error saying the table is not open.
I have tried several other things, but nothing seems to work.
I know I have it wrong, but can't figure it out.