excel: How to set up a formula for a range of numbers ie. 3.5-5..
in a spreadsheet i have a range of numbers that needed to be counted ie.
phos levels between 3.5-5.5 I can't find a formula to support this. Can you
> in a spreadsheet i have a range of numbers that needed
> to be counted ie. phos levels between 3.5-5.5 I can't
> find a formula to support this.
You're a little light on details. A concrete example might help to ensure a
clear understanding of your needs.
If you have "phos levels" in the range A1:A100 and you want to determine how
many are between 3.5 and 5.5...Filtering #8
I am working on Excel 2003. I have a spreadsheet with several columns, but
only want to filter, for example, Columns, A, B, C, D and I. How do I do
that. I have used the Autofilter, but it filters all the columns, even when
I only select columns A, B C, D and I?
Any clues anyone?
Thank you in advance
Debra Dalgleish shows here how you can hide filter arrows for those columns
you do not want to filter:
Hope this helps.
"Caroline Horner" <firstname.lastname@example.org> wrote in message
news:u%23WOj3...I can't reinstall the Personal Folders Backup
M=E9xico DF January 11 of 2003
After I reinstall Office 2003 Professional I can't=20
install the Outlook 2003 add-in: PERSONAL FOLDERS BACKUP.
I download the installer plbackup and when I start I see=20
setup has detect that you already have a version of=20
Personal Folders Backup installed on the machine. Before=20
this download can be installed you must uninstall the=20
previous version, to uninstall please answer YES to the=20
Are you sure you want to uninstall the product?
I answer YES
I see this action is only valid for products that are=20
SETUP ERRO...How to unlock Attributes in Activity, (ie Statuscode)
When I go to the attribute statuscode, I can not aquire access to the fileds,
what is the process to change the access?
Some field in CRM are restricted and stay restricted, therefore it can not
"David Neel" wrote:
> When I go to the attribute statuscode, I can not aquire access to the fileds,
> what is the process to change the access?
> David Neel
The only way you can get access to this attribute is programatically.
...Reinstall " framedyn.dll "
I've been to Google for this but
I still have not had any success .
Might there be a solution without
paying for this supposed fix ?
I'm running XP SP3 , OE 6 .
"Application Has Failed to Start Because Framedyn.dll Was Not Found"
Error Message When You Open the System Properties Dialog Box
> I've been to Google for this but
> I still have not had any success .
> Might there be a solution without
> paying for this supposed fix ?...8:00 AM shows in date field when printing Outlook form
I am in the process of developing a custom Outlook Message
Form. For this form I have created a User-defined date
field. Even though the format of this field is mm/dd/yy,
it always prints out as mm/dd/yyyy 8:00:00 AM. Why does
the "8:00:00 AM" show up when printing and how do I remove
it? This symtom is just the oposite when using User-
defined time fields.
We had a problem with IIS which meant we had to remove and reinstall it.
Since we have it back up and running IMF seems to no longer work. when
trying to reinstall sp2 for exchange 2003 it is saying a previous version of
imf exists. This is definatley not IMF v1 as we have had SP2 installed for a
while and no problems.
Any ideas how i can workaround this problem?
Just as a side note OWA has also stopped working, when inputting your
username and password you get a message saying: "HTTP/1.1 403 Forbidden". Not
sure if they are related as of yet.
Cheers in advance for any he...Reinstall of IE8
How can I reinstall IE8?
The IE8 download site recognizes that I already have IE8.
One would ask why you want to re-install IE8.
What is broken so much that you cannot fix it?
Apart from that you can only re-install IE8 on XP/SP2-3 machines by first
uninstalling it an reverting back to your previous IE version and then
downloading and installing the latest version from the IE site.
To repair IE 8 go Start>Control Panel>Internet Options - Advanced tab, click
the "Reset" button.
"BobM" <BobM@discussions.micros...EARN $ 1,434,892.8 BY E-GOLD (GUARANTEED!!) All you need is 3 People You know #11
EARN $ 1,434,892.8 BY E-GOLD (GUARANTEED!!) All you need is 3 People You know
Hello every body ,
im be glad to introduce one of the best
MLM for every body who wants to explod his/her earning with very simple steps and
If you achieve only 10% success you will still make $ 143,489.28
If you achieve only 1% success you will still make $ 14,348.928
But If we trust to each other and be serious, reaching to $ 1,434,892.8 is not seem so
far,just three or four weeks!!
The whole works that you should do :
1) You should open an e-gold account ,th...How can I reinstall my mouse by keyboard?
Windows XP Pro. SP3
My mouse stopped working for no apparent reason. Device Manager -> PS/2
Compatible Mouse Properties -> General [tab] -> Device Status says, "Windows
cannot start this hardware device because its configuration information in
the registry is incomplete or damaged. (Code 19)
Click Troubleshoot to start the troubleshooter for this device."
Troubleshooter says, "Uninstall and then reinstall your device." To do this
I must right-click the device in Device Manager and then click Uninstall ->
function that sits on the currently displayed page in IE. However if I try to
pass 2 parameters (as shown below), the 1st argument (rgvarg ) is the only
those two arguments, only the first arg (rgvarg ) survives. So I can pass
the int, or the BSTR, but not both. Is than an IE-specific restriction? I
haven't seen any generic COM postings on such an issue.
MS VC++ (2003) code:
LRESULT CMyActiveXCtrl::OnReceivedMessage(WP...Reinstall Publisher 2002
Due to drive limitations, had to install new drive. Reinstalled Windows
XP/SP2 and Office XP/SP3.
1) Can I either run Publisher 2002 directly from the disc, or install on an
external USB drive to conserve C drive space? or must I do a reinstall on C?
2) If I do install on C, can I later remove using Add/Remove and then later
I don't think you can completely run Publisher from the disk. I could be
wrong but I think those days are pretty much gone. I don't think installing
it on a removable drive will work either. Same caveat as before.
If you install/uninstall/re...Sending emails #8
For some reason my emails are being sent as I'm typing them. I can't figure
out what I'm doing wrong.
Might you be:
- activating Send via voice command (it's a long shot but possible if the
voice features are turned on)
- accidentally hitting Alt-S
"lorrab" <email@example.com> wrote in message
> For some reason my emails are being sent as I'm typing them. I can't
> out what I'm doing wrong.
...Internet Explorer 8 will not open; Outlook 2007 emails not showing
I'm having the biggest issue with Windows 7 right now. I have installed Win7
Professional and had been using it fine with IE8/Firefox and MSOffice 2007
Ultimate. About 2 weeks ago, I had a massive email download (over 1000
emails, broken up to around 270 at a time) from Gmail. This is when I
noticed that the HTML would not show up in emails that were listed as Safe
Senders. Also, IE8 will not open. There are no error messages. If I click
on IE enough times, I barely get to see iexplore.exe show up in the Task
Manager before it disappears. Firefox works fine and has bee...=?Utf-8?Q?Why_can=E2=80=99t_you_show_negative_numb?= =?Utf-8?Q?ers_in_parentheses=3F?=
you used to be able to use parentheses to show negative numbers in excel but
in the latest version (2003) they've removed this feature, you can't even set
it up as a custom format. any one know how i could do this.
I have no problems doing that with 2003, btw why can't you set it up as a
custom format? What happens if you use
? If nothing happens your dates are text and not numbers as required
> you used to be able to use parentheses to show negative numbers in excel but
> in the latest version (2003) the...How Can I Read Formatting Data (ie Background Colour)
I'm using conditional formatting to rank various numeric data into Green,
Amber, Red cells (ie Good, Average, Bad). I want to then count the number
of "Green" cells. Ican't find a way to do this directly.
PS I'm aware I could replicate the conditional format tests into another are
of the spreadsheet and apply values using @if etc, but was trying to avoid
this if possible.
See Chip Pearson's site for this.
Gord Dibben Excel MVP
On Thu, 8 Dec 2005 12:51:20 -0800, "iMartyn"
<...Outlook bar #8
if you lose the personal settings in the outlook bar due
to joining and disjoining an exchange server, is their a
way to retrieve those settings. I tried to import a
backup pst but it only had the standard outlook bar.
the bar is not in the pst, it's a file on your hard drive, so yes you can
move it if you still have access to the other computer - look for *.fav.
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...Used Windows Update and now IE is dead and so is everything that uses it
Running Windows XP, SP2. A few days ago I did a Windows Update (I always
do it manually) and chose all security patches and any non-critical
patches that seemed valid (i.e. I don't need the Australian daylight
savings time change patch as I live in the UK).
I use a non-Outlook email client and Mozilla Firefox most of the time so
didn't notice anything wrong. Then I tried to use Outlook to pick up
some email from a server and it crashed. Tried to visit some websites
with IE - crashed. Also couldn't open chm HTML Help files - crashed.
After a while I twigged it mus...IE 8 in Vista
I recently uploaded the IE8. It seems to work well enough, but it doesn't
back out of things more than one level when I'm in yahoo. For instance - I
open my email page, then an individual email. If I reply, that opens another
window, but once that email is sent off, I try to back back out and I can't
even get back to the original email nor the email main page.
I've tried looking to see if google.com and ask.com won't back up, but it
does just fine.
Anyway - is there any hope for a fix, OR how can I go back to IE7.
"APlum" <APlum@discus...Create IE object in .vbs file, and control the tinymce editor in the page
HI, my friends,
In a standalone .vbs file, I create an IE object and navigate to a
Now I want to get/set the content of the tinymce editor. Is it
possible to do that?
P.S. Can javacript be run as standalone application, just like
the .vbs file?
Thanks! Any help will be appreciated!
On Dec 8, 12:08=A0pm, Zhiguo <zhiguoyo...@gmail.com> wrote:
> HI, my friends,
> In a standalone .vbs file, I create an IE object and navigate to a
> Now I want to get/set the content...reinstall
need to change fiscal year set up and delete all non essential data, do I
need to reinstall or there is another possibility?
...Win 7, IE 8, and Adobe Flash problem
My IE 8 locks up randomly when I try to change to a different tab or when I
try to close IE 8. I've disabled the Adobe Flash add-on and the problems go
away. I removed Adobe Flash using the control panel and then downloaded and
reinstalled the add-on but the problem returns. What else do I need to check
or try to correct this problem? I have a new install of Win 7 Professional
with all the latest updates applied and the latest version of the Adobe Flash
If you're having a problem with Flash, your best chance of resolution
comes from Adobe Technical Sup...Unable to send to .IE domain
My Exchange server gives me the error:
553 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1)
"Richard Edwards" <firstname.lastname@example.org> wrote:
>My Exchange server gives me the error:
>553 sorry, that domain isn't in my list of allowed rcpthosts (#5.7.1)
Ask the admin of the SMTP server you're using as a relay. It's
probably your ISP's server that's not configured to allow you to use
it as a relay.
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swin...=?Utf-8?Q?=E2=80=9CTax_Included_with_Item_Price_fo?= =?Utf-8?Q?r_Employee_Expense_Transactions=E2=80=9D?=
We would like the Tax amount to default into the Employee Expense Entry
window (Transactions >> Project >> Employee Expense Entry) when using a “Tax
Included with Item Price” Based On option from the Tax Detail Maintenance
We do not want to drill-down to window just to see the Tax amount when there
is a Tax field within the Employee Expense Entry window.
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...how do I reinstall money after OS reinstall
I had to reinstall XP, and lost all installed programs, registry, etc. I
still have the old hard drive, so I have the installed files for money,
office, etc. But none of them are really installed. I do not see a setup
file anywhere, and trying to run the exe I get a message that I have to run
setup. I downloaded the software, and suppose I no longer have the original
Money should be able to run with the files I have, but I have to get it
Can anyone help?
In microsoft.public.money, Kenny8 wrote:
>I had to reinstall XP, and lost all installed prog...