IF FORMULAS #2
Looking for help...... In column A1:A16, I have names. In B1:B16 I will
assign random numbers to those names from 1-16. In another part of the sheet
I have 16 columns lets say D:S, (D) being column 1 and (S) being column 16.
when I assign a number in column B, I want the name to the left to appear
above the appropiate column. EX, If B1 is 16 then the name in A1 will appear
above column S.
I am using Excel 2007 Windows Vista. I find this site to be the place for
answers,everyone is great. Thanks in advance.
Fill to S1.
"JOHN...Event date problem with Entourage calendar
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
When trying to add an event in the calendar, the date defaults to January 5, 2010, and won't let you change it to the current date, or the date of the day that the event is being created on. Any suggestions?
Same thing happened to me when I first used Entourage calendar. I fixed it by checking the date/time set up under Apple preferences. Sure enough, the date was set wrong. Hope this helps.
...Shared Workbooks #2
I have 1 book being shared by 2 users. The book has
approx 30 worksheets. The sheets have a min of 10 rows to
a max of 11,000 rows and 26 columns of data.
User 1 and user 2 open the workbook and work on different
sheets of the book at the same time.
User 1 changes the format of cells, saves the changes and
User 2 has the file open, continues to work on the
user 1 reopens the book, makes changes, saves, and exits.
2 saves and exits the book and user 1 reopens the book,
the formatting is lost.
The file is also 24+mb, does this have a factor...Missing row #2
A user has deleted a row that had an amount in it. Her rows are now number,
23, 24, 25, 27 (so row 26 is missing). Whenever she tries to total columns
or rows, the number that is in that missing row is calculated in. How do I
retrieve that row, or clear out the number?
Select rows 24 and 26, the whole rows and goto Format>Row>Unhide.
(remove nothere from the email address if mailing direct)
"Kim" <Kim@discussions.microsoft.com> wrote in message
> A user has deleted a row that ha...CRM1.2 and Contract Template
Is there any way to customize the "Contract Template" screen
from the "home","settings","template manager","Contract Templates","New
Contract Template".. Can I customize this form ?
I need to enter "Reponce Levels" in the dropdown list...
Is this possible and if so how....?
Contract Template itself is not customizable. However, if you want the
"Response Levels" picklist to show up on each contract that gets created,
you could customize the Contracts Form itself and add the picklist. This
field...spin control problem #2
How do I get the integer value of a spin control's associated edit control
while in the edit control's OnEnChange function. Everytime I try to extract
the data I get an exception error.
If you have a problem in spin control, hire a good publicist... (sorry, I couldn't resist)
First, show the code. Then say PRECISELY what you mean by "exception error", showing the
exact line of code that experiences the problem. Otherwise, there is no way to tell what
On Thu, 26 Jul 2007 07:43:21 -0700, "Z.K." <email@example.com> wrote:
...ComboBox.Text gets reset between event calls
I am trying to make a ComboBox that will AutoResize to the text being
displayed. The steps I take are:
private void ResizeTextBox()
CurrentGraphics = this.CreateGraphics();
thisText = this.Text;
this...Free business opportunity #2
If you need to make 2,000 - 5,000 per week - you need to check this out. No cost or obligation full details.
MAF Anti-Spam ID: 20041209205203P0d4HhB4
...Import of Data into RMS 2.0?
We will be converting to RMS soon. Is there anyway we can import our old
sales history(Monthly) into RMS 2.0?
I am not aware of a free utility that will import all data, including sales
transaction history to your RMS system. Retail Realm has an Import Tool that
will do this if your current system is Microsoft Point of Sale, possibly POS
2009, but it is licensed (meaning you need to pay for it).
Otherwise, I believe you are limited to importing items, customers,
suppliers, and UPCs as Aliases, no history.
"newbierms user" wrote:
>...Exchange 2003 : Log for an email process...
How do I check the log for an email. For example, user A mailbox, what is
the incoming and outgoing emails for that mailbox for the past few days ?
Use the Message Tracking feature in Exchange System Manager. This uses the
tracking logs held in the servername.log share under your \exchsrvr folder.
There are 3rd party tools that can elaborate on these logs, two of which I
For Exchange news, links and tips, check:
&quo...Macros on Protected Sheets #2
Now I have tried Alan's Solution to be able to run my Macros in Protected
sheets but as I am not VB literate, I think I have made a Syntax mistake.
Sheet("Critical Path").Unprotect ("My Password")
' Newaction Macro
' Macro recorded 17/11/2004 by Clifford
Selection.AutoFilter Field:=1, Criteria1:="="
Sheet("Critical Path").Protect ("My Password")
I receive a message "Compile error"
"Sub or function not defined"
Can you tell me what's wrong ?
I am a bit confused with the tracking ID in CRM 1.2
We are not using SFO and CRM is configured to receive all incoming emails.
Customers are sending their enquiries using two ways:
1. By email and then the email is turned into an activity in the
corresponding queue(CSR has to create the Case and link the incoming
activity to it)
2. Using a front end (web) application that links to the CRM. In this case,
a case(sorry!) is automatically created in the corresponding queue.
At the very beginning of the installation I have turned off email tracking
ID but now I'd like that whenev...eseutil /p #2
I had to run eseutil /p since /r was not working, and my exchange 2003 priv
and pub were not coming up. i ran it on pub1.ebd ran ok and i was able to
mont the public folder. eseutil on priv is currently running and is at a
point were it seems that nothing is happening, is says deleting unicode fixup
table .? how long will this take. is it normal ..??
Do you have a backup that you can restore from (if necessary)? How big is
your priv? How long has eseutil been running? Might be time to get PSS on
"Alfred" <Alfred@...Printing Different Invoice Forms depending on Customer Class ID
We bill in multiple currencies for multiple countries. Does anyone know how
to automate the procedure to print the SOP Invoice document on different
forms based on customer Class ID or currency?
How different are the formats? You might be able to use one format with
conditional formatting for elements on the report.
"Burke Gladding" wrote:
> We bill in multiple currencies for multiple countries. Does anyone know how
> to automate the procedure to print the SOP Invoice document on different
> forms based on customer Class ID or currency?
...Free/Busy: "No Information" After May 31
It was brought to my attention that when my users go to schedule
appointments the scheduling part of the free/busy shows the striped "No
Information" as soon as it hits June 1. It's not like it is only going out a
certain number of days...it stops showing info after May 31.
We are running Exchange 2003 with mostly Office 2003 clients. I am not sure
where to look.
Here's a starting point for you. It has the architecture of free/busy and
"mpallo&qu...mail merge- 2 things
Help! I have folks on my mailing list, same address but
different last names. When I merge that way, it shows
them correct but the others either.....sam smith and judy
smith or The Smith family. In a perfict world I would
like it to merge...... jen doe & sarah miller and sam &
judy smith. What can I do?
Next, when I save the mail merge to a cd to take to
Kinkos to print they say "you need to load up this file
prep tool & save it that way first, oh but you have XP so
this won't work, you need to buy a distiller". Well I
just looked at what I think is ...CC: name showing user ID rather than full name
Why would the name in the cc:, etc. fields show as the
user ID rather than the display name or email address
Is this a pop quiz or did you want some help with this? If the latter,
provide some information.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
| Why would the name in the cc:, etc. fields show as the
| user ID rather than the display name or email address
...Outlook 2007 Error #2
The Operation Failed. An Object Could Not Be Found.
I get this error when I use Outlook 2007.
I followed the instructions I saw on a Microsoft Support document that
told me to create a new profile.
I created a new profile, (no big deal), but it has not solved the
Any other ideas??
As far as creating a new profile, I deleted the original default
profile I had and created a new one. anything more complicated than
I have 3 different profiles:
One for my GMail account
One for my Verizon Account
One for my one domain name account, (my default, or mail account).
Did you use...Trial version activation #2
When the dialog for activation over the inet pops up, it cannot find my
connection. I use broadband cable and I know I am connected. Does anyone know
how to correct this so that I can activate the software?
...Unable to access OWA #2
i have no problem accessing OWA using the FQDN. eg.
But when tried to access OWA using public IP address, eg.
http://184.108.40.206/exchange , it shows "The page cannot be found".
DNS server has records for both forward & reverse.
You should ask this in an Exchange group as Outlook Web Access is a part of
Exchange, not Outlook.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading...Macro to save file to a specific directory depending on the day of week #2
Many thanks to icestationzbra & AlfD it worked a treat
can anyone please advise me how to incorporate both the time and dat
into the formula " & trim(format(date,"dd-mmm") & ".xls")
44 Married two kid
robertguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=596
View this thread: http://www.excelforum.com/showthread.php?threadid=26192
MsgBox Format(Now, "dd-mmm_hhmmss") & ".xls&...2 axis bar graph
I have a 2 data item column graph for 6 data points in time. One in %, one
is a number. I want to use a 2 axis graph, but when I try and change the
axis on one of the data items the graph switches to a stack bar graph with 2
axis. Any thoughts on how to keep it a double column graph with 2 axis?
It does not really change to a stacked bar chart. To illustrate, once you
have set your axis, right click on one of them, then click on format data
series. Now click on options, and change the gap width to say 40. You will
see that your percentages line up with the relevant axis, while the...Greater than and Less than #2
I am trying to set up a formula to tdisplay the following info
If cell a2 is greater than 2 and less than 95 enter "yes", if not, leave blank
I know how to use the if command for one part (=if(a2<2,"yes","") but can't get the second part
Can anyone help
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"FrankG" <firstname.lastname@example.org> wrote in message
news:B0E60417-717B-4BC1-98EA-10C...Calculated Field of the Average+2*stddevp in pivot table
I have a pivot table that includes columns (fields) for Average and
Stddevp. What I would like to do is include a new column ( Calculated
Field ??) of the Average+2*stddevp or better yet =Percentile( variable
name,.8). I cannot get these to happen. Any help would be greatly
...MX Records #2 #2
I would like to setup an MX record #2 of weigh 20 for another location - not
on same domain or even same network. The goal is to hold mail in case that
primary MX record / server is down. How do I setup the SECOND server for
this setup? Thank you.
On Fri, 21 Apr 2006 12:41:55 -0500, ">>Smith<<" <email@example.com>
>I would like to setup an MX record #2 of weigh 20 for another location - not
>on same domain or even same network. The goal is to hold mail in case that
>primary MX record / server is down. How do I setup the SECOND server for...