Find difference between 2 cells if critera in a 3rd cell is met
How would I find the difference between two cells depending on what is in a
third cell? For example, in column G1 I want to show the difference E1 and
whichever cell in column F contains the number 1. I was thinking something
along the lines of using SUMPRODUCT to find the row with the #1 and then
somehow subtracting G1 from the number column E that match the row where the
number 1 was found.
This is VERY confusing! At least, to me it is.
There's probably a simple solution but I don't understand.
You want the formula in cell G1?
This is the really confusing part:
...I need some help #2
What I need to be able to do is return a range of data based off of
calculation. Here is an example of what I nee
Ok, I need to find all product that is 1.3 times higher percent, an
.77 times lower in percent than Widget at 36.27
Basically return all values that are between 36.27*1.3 and 36.27*.7
and equal to 36.2
Can anybody help me do this
Ilneval's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3116
View this threa..."The Operation Failed" #2
This is the message I get when I try to open Outlook 2000. I'm
running Win2K. I recently had a serious crash and my computer is
still not stable. However, I AM able to run Outlook Express. I've
had viruses, which are cleaned out. (Bliss, Hacktool.Sechole). And
whenever I start up any of the Office programs, they go through the
"installation" process as if they were never started before. It's as
if the computer has no memory that they've already been installed.
Any assistance would be greatly appreciated. Thank you.
I have disabled the Word
editor, I have changed the overall format to plain text
as well as for each individual contact and to no avail.
They still get winmail.dat files regardless of the type
of attachment I sent (.doc,.jpg,
etc...) It appears fine in my sent folder and the
attachments arrive as the proper
attachment when sent to myself, but not to anyone else.
They either arrive as winmail.dat or no attachment at
all, even to those using Outlook as well.
I am NOT using RTF or word as my editor.
We are also experiencing this within my organization.
Sender is using Outlook, Rich...lost data #2
Is there a way to retrieve a file that has been "saved
over", both on a floppy and my network.
Not unless you or your Systems guys have backups...
>Is there a way to retrieve a file that has been "saved
>over", both on a floppy and my network.
On a floppy, No. On a stand alone PC, No. On a networked system, probably
yes. These are normally backed up daily.
"E Barnes" <email@example.com> wrote in message
> Is there a way to ret...TEST DRIVE removal #2
i don't even recall installing TESt DRive. but i did. Now i want to get
rid of it. But i've already installed my full MS office? How can i
remove test drive w/o having to reinstall my Office SW?
...Crystal Reports, CRM 1.2
Read the following in past newsgroups:
"Microsoft CRM v1.2 ships with a specially configured copy
of Crystal Reports v9.0 but you will need to purchase the
licenses from your usual sources to activate it.
The other option is to purchase the Professional or
Developer edition of Crystal Reports v9.0 and use the
enhancement patch that is available on your CRM server CD
to configure it for Microsoft CRM. I believe this option
will work for Crystal Reports v10 as well.
For all options you only need to purchase licenses for
those users responsible for customising reports as you
would n...Cell Comments #2
Is it possible to view the content of a group of cells in
another part of a worksheet in a cell comment.
I do not just want to input text but rather see the
content of a group of cells.
Thanks to anyone out there who can help, it's appreciated.
this would only possible with VBA. e.g. using the
worksheet_change event and creating the comment
>Is it possible to view the content of a group of cells in
>another part of a worksheet in a cell comment.
>I do not just want to input text but rather see the
>content of a g...Excel getting closed giving an error message that some illegal operations occure
I am not able to open an excel file created by me. I
created some macros in this book and later deleted all the
macros. When I attempt to open the work book it says the
This program has performed an illegal operation and will
be shut down.
If the problem persists, contact the program vendor.
EXCEL caused an invalid page fault in
module EXCEL.EXE at 017f:3009f643.
EAX=00002ffd CS=017f EIP=3009f643 EFLGS=00010216
EBX=0062ae52 SS=0187 ESP=006292e4 EBP=0062935c
ECX=fc00001a DS=0187 ESI=0221c248 FS=408f
EDX=0207000c ES=0187 EDI=025346e8 GS=3d76
Bytes at CS:EIP...Quick Exchange 5.5 Question #2
With MS Exchange 5.5 Enterprise edition, is there a
maximum size for an individual mailbox or is this simply
determined by available hardware as well?
"Jonathan M. Lerche" <firstname.lastname@example.org> wrote:
>With MS Exchange 5.5 Enterprise edition, is there a
>maximum size for an individual mailbox
none that i know of. when the mailbox passes 2GB the displayed size
will be incorrect, but that's not a limitation.
>or is this simply
>determined by available hardware as well?
MCSE+I, Exchange MVP
MS Exchange FAQ at h...illegal xml character
one night after i have finished my project on word07, i saved it in my USB
flash disk. And on the next morning i would like to make some ammendments to
it, i caouldn't open the file. It says, error occurs when opening the file.
Detail information as follows:
Illegal xml character.
Position: wor/document.xml Row2
i tried to open it after i have saved and it worked!!
my file is extremely urgent!!
could anyone please help, please !!!
What has happened is a tough lesson. Never use Word (save or work) directly
with any type of removable media. Always copy to...2 criteria for query
How would I write a query where I want to find a conflict of user profiles
sorted by id's? I have a table listing user id's, names, and profiles. I want
to find users with conflicts. For example if a user has profile 2001 or 2002,
then they can not have profiles 2012, 2014, 2015.
hmm, Excel or Access?
On 10.12.2009 18:11, NeedExcelHelp07 wrote:
> How would I write a query where I want to find a conflict of user profiles
> sorted by id's? I have a table listing user id's, names, and profiles. I want
> to find users with conflicts. For ...Folders #2
I had a really large folder that I lost when I clicked "close" under folders
I can't find it to restore it to the folder listing, or any of the emails within it
...Upgrading to Office 10.4 and 10.5 #2
I am running System 10.3 and have office. I have upgraded to 10.1.3
but when I try to upgrade to 10.1.4 and/or 10.1.5 I get messges tht
say sometimes it cannot find office on my computer and at other times
that I need the earlier updates. has anyone any ideas? Many thanks,
You needed to update to 10.1.2 first or you get problems...
Microsoft Office v. X 10.1.5 Update=20
This update addresses several stability issues w...Date Picker #2
Is there anyway I can link Date Picker to a macro after a date has bee
selected from the calendar?
If yes, how
Message posted from http://www.ExcelForum.com
I experience a stange issue, the user email@example.com tried to send an
email to firstname.lastname@example.org and he received this error message:
"The message could not be sent because one of the recipients was rejected by
the server. The rejected e-mail address was 'email@example.com'. Subject 'Test',
Account: 'tata', Server: 'smtp.example.com', Protocol: SMTP, Server Response:
'550 5.1.1 unknown or illegal alias 'firstname.lastname@example.org', Port: 25, Secure(SSL): No,
Server Error: 550, Error Number: 0x800CCC79.
But tata can send an email to another user email@example.com (ti...Out of office reply message #2
I have a user that I am trying to help set up an Out of
Office reply to run while she is away. We are using
Outlook 2002 and she is running Windows XP. I understand
that the Out of Office assistant will only work with those
users on our Exchange server so I am trying to set up a
rule to allow users outside of our office to see this
reply. I created a reply text message, saved it as an
Outlook message template and turned on the rule. While her
Outlook is running, I opened up Internet Explorer to
access an email account other than Outlook (AOL), sent an
email, and received the...freeze 2 panes help please
hi all...... i hope this is an easy ? I want to make a worsheet kind
of like a framed web page, like this
| title || date |
| || |
| info 1 || |
| ...Outlook Bar #2
If I select to use the Outlook bar I can see the ICON's
for the selected folder. But I can't see any of the e-
mails in that folder. In other words in previous versions
of outlook I would click on the calendar icon and to the
right of the bar my calender would display.
All I can see is the Outlook bar Icon and if I click on my
inbox the the result bar shows me how many items are in
that folder but the list of e-mals wont display.
How can I correct this? Is there a patch?
Your VIEWS are messed up. Open Outlook and try adjusting
the views. This can be tricky if your not seein...MFC Printing issue #2
Ok, let's see.
OnDraw method draws 2 rectangles, one with top-left point is (0, 0) and
bottom-right point is (400, 400). The other one's top-left point is
(200, 200) and it's bottom-right point is (600, 600).
Since the view inherits from CScrollView, it's easy to make it scroll
"on the screen" so the point (200, 200) is shown in the top-left corner
of the screen, so the second rectangle appears to be drawn from (0, 0)
to (400, 400).
Now, the big question is: how can I do it in the printer?.
When I set the viewport's origin, the print preview shows everything
O...Visio Question #2
I asked this before and received one answer but I replied and did not
receive another anser.
I just installed Visio 2000 SP2 on my Dell Laptop running Windows XP Home
SP2. When I run Visio 2000 I get these errors in my event log over and over
Event Type: Warning
Event Source: MsiInstaller
Event Category: None
Event ID: 1015
Time: 7:05:05 PM
User: TGKW001\Thomas R Grassi Jr
Failed to connect to server. Error: 0x800401F0
For more information, see Help and Support Center at
Does anyone have...RE: #2
Im looking for a good, effecient DOS POS program. Ive already tried Dave
I am desperate for some help. Since yesterday, I get a
message on my Outlook as so as I open it that it has
performed an illegal operation. Details state that there
is an invalid page fault in module
MSO9.DLL@016f:308f3e51. The only day that I have 2
important e-mails to open and I can't get in. Does anyone
have a suggestion???
Read this for a start and see if it helps:
>I am desperate for some help. Since yesterday, I get a
>message on my Outlook as s...Change "1,2,3..." to "one,two,three..."
How can I change "1,2,3..." to "one,two,three..." in Excel? Using Format or
does excel got this function build in? Thank you!
No built-in. At http://www.xldynamic.com/source/xld.xlFAQ0004.html there are
some examples of converting numbers to words, but they tend to be for
monetary amounts, so you will probably need to call it a number of times and
concatenate the results.
(remove nothere from the email address if mailing direct)
"q0_0p" <firstname.lastname@example.org> wrote in message
news:36C5C77E-D908-424E-B74C-E3FBB9A403E6@microsoft.co...IMAP/PDA suspect operation.
We are currently using an E2K3 server on an up to date W2K3 server. We are
experiencing some slightly odd behaviour with some of our PDA clients
downloading email to their mobile devices using IMAP.
Out of 25 users, about 3 or 4 of them are not getting some mail downloaded
to their device. If you check their mailbox in OWA you can see mail that has
not been opened or moved and has apparently not been downloaded to their
device. You can then send them a new email which will be successfully pulled
down to their device but the other emails still stay there untouched. Why
would this be so?...