Too Many IF Statements Nesting Error (Excel Formula Loop w/o VBA)
Hello Excel Problem Gurus,
First of all, let me thank you in advance. I find it exemplary that
you all can devote time to helping others who are having issues with
their work. Hopefully one day I can be at a mentor level, and help
Hope you can help! I have an issue where I don't know how to write the
formula that I need without going over on the nesting. The current
formula that I have is as follows:
Data",IF(V7="Yes",&qu...Using rules wizard to send to a list of emails addys in BCC
i need to setup an automatic mailing of a newsletter that
i receive, to be forwarded to a list of emails addresses,
where the emails are inserted into the BCC line, and not
the TO line.
I do not want my clients to see each other's emails.
No, natively you can't. Even when you use a template to reply with and fill
in the BCC field it won't work. It is even worse this way; the rule gets
But programmatically it is possible although not supported by Microsoft. For
Robert Sparnaaij [M...Office 2003 on WinXP is receiving an error...
This operating is not presently configured to run this application.' This
nmessage keeps popping up after I install WInXP Sp2. Right after I install
office 2003, and I try to open MS word 2003, the above message appears. Can
anyone point me in the right direction?
Insert office cd>repair
"RodneyJ" <u58446@uwe> wrote in message news:a43130535cd3e@uwe...
> This operating is not presently configured to run this application.' This
> nmessage keeps popping up after I install WInXP Sp2. Right after I
> office 2003, and I t...Running Money 2003 in Vista
I run this version perfectly satisfactorily in my Vista Ultimate
desktop.with my normal log on. No fiddling was required to get it to start.
It worked perfectly out of the box, just as in XP
Referring to emails on earlier versions in the Newsgroup, my data is in a
Documents folder on the D Drive well away from Vista, though it is secured.
In this machine SSL2 is not enabled
I have a newish laptop running Windows Home Premium with a similar
configuration for all my data on the D drive. I recently tried to open
Money for the first time since installation using a copy of the Money fil...Time Series
I have about 30000 lines of data that looks like so:
Where ColA is time. I am having trouble creating a graph with time on the
x-axis and count on the y-axis.
Thank you in advance.
You need to make an XY chart
But with 30,000 data points you could run into trouble; Help says you can
32,000 data points in a single data series.
However, if you want markers it will look like heck.
You could limit the data like this:
assume y-values in B2:B30001
in ...Errors saving to network drive
When my users open an Excel spreadsheet located on a
network drive, make their changes, and then try to save
the spreadsheet, they get an error message saying "Your
changes could not be saved to Whateverfile.xls, but were
saved to XXXXXXXX ( 8 digit hex number ). Close the
existing document, then open the temporary document and
save it under a new name"
The users have been explicitly granted full rights,
including Delete and Modify, to the shared folder in
which the spreadsheet resides.
I have disabled their Symantec Antivirus realtime
protection for the time being.
This pr...Can SUMPRODUCT be used for entire column?
This formula results in a numeric result:
but this formula results in a #NUM! result:
Which means I need to specify the length of the columns, which may grow over
time. Any way to do this for the entire column, without having to specify
the length of the column?
XL07 removed the limitation on array formulas (which SUMPRODUCT is, even
though it doesn't require CTRL-SHIFT-ENTER) and entire columns.
For pre-XL07, one can use
to get all but on...Using scanner in Word97
I want to scan a picture into word97 using my HP 4370 ScanJet. Could not
find option of "From Scanner" under "Insert" --> "Picture". Apparently I
must need some sort of Word97 Add-On. What and where is the add-on? Is it
on the Office97 CD? Same applys to Excel97.
Also, does microsoft sponsor a Word97 / Office97 discussion group? If so,
would appreciate a link.
"PSRumbagh" <PSRumbagh@discussions.microsoft.com> said this in news item
> I want to scan a picture ...How to make Run Integration work in GP 10
Can anyone tell me how to make the Run Integration tool work in GP 10. We
just did our first client upgrade to GP 10 and the client has only 1
integration that they used to be able to run via the RUN INTEGRATION Tool.
Any help would be greatly appreciated.
I have the same probelm...did you get any answers to this?
I have to go into Integration Manager to run it b/c Tools>Run Integration
does nothing. I even checked the ini files to make sure the path is correct.
"Tammy Chavez" wrote:
> Can anyone tell me how to make the Run Integration tool work in...Using later version of microsoft access
I've got access 2000 on my computer. When I go to open a database someone
sent me I get an error message :
this database is in an unrecognized format. The database may have been
created with a later version of microsoft access.
Is there any way I can open and use this file (short of upgrading to later
version of access)?
If you do not have Access 2002 or 2003, ask the person to save it in Access
2000 format for you.
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at m...Separating Date and Time in a cell
I have a column of cells in the format "11/01/02 06:21". I would like to
separate the text into 2 cells - one with the date and the other with
the time. My attempts with LEFT and RIGHT have been unsuccesful. Thanks
for your help
Message posted from http://www.ExcelForum.com/
For the date use
replace A1 with the first cell of your range
you probably have to reformat the first to
mm/dd/yy (or whatever the setting is)
Note that you can do this by just using format but if you want to compare to
other cells with just pure d...Using Company Wide Mail Templates.
I do not know if i am at the right spot here, or if it is evne possible, but
i got the following question.
My boss would like me to make sure that every outgoing mail has the same
looks. It starts by adding a signature that is the same for everyone, except
with ofcourse personalized information. This was easily done by giving
everyone a signature.
The next question is however, to put the head of our website, also above our
mail. This means that every user that sends a mail, the mail will have a nice
header, underneath that header, the mail is typed, and then its ended with
the si...Dynamic Range Selection Using VBA
What I'm trying to accomplish is to be able to run a procedure that selects a
range based on a number provided in another cell. For example; if the number
10 is in cell A1, then cells A20:A30 would be selected when I run the macro.
If the number 6 is provided, then cells A20:A26 would be selected. Not sure
where to start, so any help is appreciated.
this may do what you want
"TEK" <TEK@discussions.microsoft.com> wrote in message
news:DA9FFF99-FC28-...Error loading XML into DataSet
When I try to load this xml file (see below) into an asp.net dataset
using the following code:
I get the following error:
"The same table (description) cannot be the child table in two nested
If I take out the anchor tag in the description it works fine,
however, I need the anchor tag in there. Does
anyone have any suggestions?
<?xml version="1.0" ?>
<link>http://liftoff.msf...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Multivalue with Null value SSRS 2005
I have a query to populate a multivalue parameter:
SELECT distinct cast(AGRPYear.value as varchar(4)) + AGRPMonth.value
FROM TPROJECT AS TPROJECT
One of the values that is returned from this query is NULL. However, when I
run the report, the NULL value does not show in the dropdown. I've also
"select NULL as 'ReportDate' union" to the above query and the null value
still doesn't show.
As a result some of the records in my database have a null value for this
field, they will never show up on my report. Any id...Run time error 5 : HQClient
When I double click HQ Client I have message box "Run time error 5 : Invalid
procedure call or argument"
how should I do? I used RMS 2.0
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGr...LNK2001 and LNK2019 errors with template class
This is a multi-part message in MIME format.
I have a smart pointer class that uses template functions that works =
fine under VC6 but it not linking under VS2005.
1>TestGridToolkitView.obj : error LNK2019: unresolved external symbol =
"void __cdecl PrismGCSmartPointer(class CPrismSmartPointer<class =
CDialog> &)" =
referenced in function "protected: __...Money 04 runs very slow
file size is 17,480 kb, about 5 years data. Machine is a
P4 2.2 GHz, 512 mb ram.
Money runs very slow, processing downloaded statements,
switching screens, etc.
I switched from Quicken about a year ago. That didn't run
nearly this slow. Any ideas?
Will trimming the file size help at all or much?
Ideas? See http://umpmfaq.info/faqdb.php?q=4. Trimming? Most people haven't
had great luck trying this through means like File|Archive--which, by the
way, I'd discourage for any number of reasons.
"Tom Orlando" <email@example.com> wrote i...delivery failure error
"The e-mail account does not exist at the organization this message was sent
to" then says user unknown, even though other comupters don't have that
I get this error for a few clients, yet other clients can email the same
I have Windows small business server 2000, I am pretty sure everything has
updated patches. I know i security updates automatically. My clients are an
updated Windows XP SR 1 with Office 2003(outlook) SR1.
...on Writexml error
(Type your message here)
I have a XML file as a datasource. I read that file using dataset.readxml.Then in that dataset I make some changes. Now I want to write that changed dataset by overwriting the file that was created initially.
I someone please tell me how to do it.
From: ratnesh gupta
Posted by a user from .NET 247 (http://www.dotnet247.com/)
...Excel error 1706
Whenever I try to start excel on my computer it displays
an error message and it shuts itself down, any other
program from the office pack works properly, except for
the one I mentioned. I reinstalled it and it does the
exact same thing.
Thanks in advance.
...Error with Bold
Range(Cells(1, 1), Cells(1, 2)).Font.FontStyle = "Bold"
Take a look at the activesheet. I bet that range is bolded.
But if you want Recent to be the sheet with the change, add a couple of dots.
.Range(.Cells(1, 1), .Cells(1, 2)).Font.FontStyle = "Bold"
Without those dots, the range refers to the activesheet (if the code is in a
> What's wrong?
> With Worksheets("Recent")
> Range(Cells(1...Oulook 2003 dial up sync errors
we are using outlook 2003 will all current updates
insatlled and are using cashed exchange mode. our
operating system is windows 2000 SP4 with all the current
updates as well. when the user connects and hits f9 to
sync we get the following error in the sync log (i have
run detect and repair and removed and recreated the users
outlook profile) any suggestions??:
18:57:44 Synchronizer Version 11.0.5604
18:57:44 Could not connect to public
18:57:44 The Microsoft Exchange Server
computer is not available. Either there are networ...Error loading outlook 2003
Hey Guys need a little help
I'm running office 2003 with outlook, I'm using my own
exchange server, everytime I load up outlook on one of my
workstations it loads up fine until I hit the inbox, once
I do that Outlook closes down, I check in the event view
and got this error message:
"The MOF file created for the outlook service could not be
loaded. The error code returned by the MOF Complier is
contained in the Record Data. Before the performance
counters of this service can be collected by WMI the MOF
file will need to be loaded manually."
Anyone know a fix inste...