I have many different long formulas and I need to name each of them
This way I will be able to say: Choose(A1, ATV,AVG,Unit)
If cell A1 = 2 the cell will use the function AVG and show the results
My problem is when I create the functions I get an #Value in cell
Lets say AVG is one of my Function
In VB I have:
ActiveCell.FormulaR1C1 = "=AVERAGE (RC[-3]:RC[-1])"
In Excel I have
In Cell A1 = 2
Cols----> b C D E
Row2--> 100 50 100 =Choose(A1,ATV, AVG,Unit)
Beca...Summing by Date Range
I have a spreadsheet containing purchases made at various suppliers.
Columns are Supplier, Invoice Date and Amount. It's easy enough to use
SUMIF and return a figure for how much I spent at each supplier, but I
can't figure out to calculate how much I spent in a given span of time,
or better yet, how much I spent in a given timespan at a given
supplier. Right now my primary concern is calculating how much I spent
in each tax year, say, from Jan 1, 1998 to Dec 31, 1998 and so on.
It must be simple but I'm breaking my head on it. Any takers?
To sum for a specific time-spa...Which Mac Office 2004 licenses have I used?
Hey there - we're struggling with office 2004 at the moment; we must
have installed the same license key on more than iMac - can someone
tell me how to check which of our 3 licenses we've used? We have a 3
license version, installed twice and they won't let each other run
simultaneously (without pulling out one of the network cables that is)
Hiya to change the licence:
1. run the Office Removal tool, you will find it here:
Applications/Microsoft Office 2004/Additional Tools/Remove Office/
2. When the first screen appear "Welcome to r...Can i use a MFC control in a non-MFC window ?
I'd like to use a MFC control in a non-MFC window (for
Is it possible to link this control to my window handle ?
The requirement when developping a GINA is that i have to
use the DialogBox function provided by the Winlogon, and
so, I can't use a pure MFC dialog box without overloading
the DoModal function and it's a big mess.
For one of my windows i want to use the CListBoxST class
found on CodeGuru.
So i wanted to create a CListBoxST objet and attach it to
my window handle.
Is it possible without having to "port" the whole class
in Win...How to Control Template Styles when using Word as Email Editor?
I have a "funny" thing going on with Word and Outlook (Version 2003 in
Configured Word as email editor, sending in "plain text". Worked great.
(main purpose is to get Word's writing not formatting features).
While writing in Word (nothing to do with Outlook) I changed paragraph
format for "normal" style in normal.dot to "6 point after", e.g. 1/2 a
line. Didn't like that change to changed it back. to "0" lines after.
Ever since that change, when editing email in Outlook, it has 1/2 line
spacing after each paragraph. Thi...Hotmail and MS Exchange using Outlook 2003
I have a client using Outlook 2003 on a Win XP SP2 workstation attached to a
SBS 2003 server running Exchange 2003. This client uses Hotmail for his
public (external) e-mail, but uses Exchange server to send e-mails to other
LAN users within the office. Everything works OK, except that each time he
reboots the workstation, Exchange becomes the default e-mail transport. This
causes messages sent via Hotmail to fail. We can work around the issue by
setting Hotmail to be the default transport after we reboot, but the
settings don't persist through a reboot of the workstation.
Does any...How to I use ** without Excel thinking I want to type a formula?
I am using Excel (Office 2003) to create a table and I need to use two of
these: * to indicate significant results for a research study. How do I tell
Excel that I just want to display this symbol after a three digit number
without it thinking I want to type a formula?
Turn off Lotus transition under tools>options>transition and uncheck
transition formula entry
> I am using Excel (Office 2003) to create a table and I need to use two of
> these: * to indicate significant results for a research study. How do I tell
> Excel th...Dynamic Range??? Please Help
=IF(C7="","",VLOOKUP(C7,'Sheet3 (2)'!$A$2:$C$152,2,FALSE)) this is my formula
I would like to be able to add the list. I tried following the dynamic range
instrutions but it's not working. Thank you
hen I add to the list I want some with the formula and so without. Is that
What determines the bottom of your list? Col a, b or c?
on the sheet where the list is>insert>name>define>name it mylist or whatever
in the refers to box type
Don G...Edit Named Ranges
I have a Named Range, Alaska, with the cities in Alaska
I need to add more cities, so I need to change the range to includ
Also I have a named range, Alabama, with cities in Alabama.
I need to delete cities, so I need to change the range to include les
Any Advice or hints?
thank You in advanc
Message posted from http://www.ExcelForum.com
Try dynamic ranges:
In article <email@example.com>,
monagan <<firstname.lastname@example.org>> wrote:
> I have a Named Range, Alaska, ...using outlook #2
can someone tell me how to start using outlook and how to get it to receive
my emails direct into outlook?
I don't know what version you are running but try this. Open Outlook and go
to the Tools Menu. Select either Services or Accounts and begin to set up
your account. You will probably need to add an Address Book, and Personal
Folder, and an Email account type. We normally use Internet E-Mail. You will
need to configure the account type with name, address, and maikl server info.
> can someone tell me how to start using outlook and how to get it t..."IF" Function question
I am trying to create a spreadsheet to keep track of scores. Each score has a corresponding number of points. For example if the score is between 170 and 174.5 the number of points is 1, if it is between 175 and 179.5 it is 2 and so on up to 200 where it is worth 8 points. I can't seem to figure out how to tell excel that if the score falls between two numbers display this value. I have tried it multiple ways such as =IF(D8>=170<=174.5,1, IF(D8>=175<=179.5,2, IF(D8>=180<=184.5,3, IF(D8>=185<=189.5,4, IF(D8>=190<=194.5,4, IF(D8>=195<=197.5,6, IF(D8...Count/Sum rows of a column depending on criteria from drop-down li
I have a question here, appreciate any help.
Prod ID Jan Feb Mar....
Prod A 10 5 3
Prod B 3 - -
Prod A 4 7 1
Prod C 5 2 7
In Cell A8 = Prod A
At cell B7, it is a data validation(drop-down list) for Jan~Dec
In B8 cell, I need a formula to calculate When Prod ID = Prod A and when
month selected is Mar, the sum, ie. result is 4.
In C8 cell, I need a formula to calculate When Prod ID = Prod A and when
month selected is Mar, the count if value is > 0, ie. result is 2
I know I may have to use sumproduct, som...Printing using MFC ??
I have some printing related Qs in MFC frame work.
1. How to print big text on multiple pages. My undersatnding is that for
every page OnPrint is called, Is this correct ? So OnPrint will be called n
number of times ???
2. How can I put some gaps between text and start the printing on a new
Check out the following link (beware of wrapping):
Abstrakt Mekanik AB
"harvinder singh&qu...@which function to use when
Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
54.52 and I want to know which fuction/formula to use for making these as
88.25, 89.00, 72.40, 54.50. Please help. Thanks.
On Sat, 9 Jan 2010 01:43:23 +0530, "Sandeep Lohchab"
>Sir, I have a row in excel with cells containing 88.23, 89.01, 72.39,
>54.52 and I want to know which fuction/formula to use for making these as
>88.25, 89.00, 72.40, 54.50. Please help. Thanks.
Try this formula:
Hope this helps / Lars-...Use of the DSUM function
Who can give me a hand?
I am using the function below; so far so good.
DAvg("[wng_OPP_SLPK1]";"TBL_Woningen";"[wng_CFT Code] = """ & [pdt_CFT code]
Now I need to generate a sum on a field that contains the value "J". How can
I change the function:
DSum function where the field to sum is wng_COD_INDCV (with the text "J"),
the table TBL_Woningen and the criteria [wng_CFT Code] = """ & [pdt_CFT code]
& "...Named Range #2
I've named few ranges through VBA by using this code
For i = 1 To 15
' Define the name for the variables
ActiveWorkbook.Names.Add Name:=Worksheets("ST> DATA").Cells(1, i),
"=OFFSET('ST> DATA'!R1C1,'ST> DATA'!R1C214," & (i - 1) &
which is working fine, but when i try to refer it in a chart, an error
msg is popping up saying "Your formula contains an invalid external
reference to a worksheet, Verify that the path, workbook, and range
name...search two tables for all dates in range
(Access 2003) I have a union query which combines all dates for an activity
from two tables (Itinerary [ReviewDate] and Itinerary Dates [ReviewDates]).
I then have another query which links this query with the Itinerary table
and filters on a specified period (startdate and enddate), it only shows the
records and start dates from the Itinerary table so I get the Itinerary
displayed only once. This returns the correct recordset but it is not
updateable and I need the user to be able to edit the records on my form. Is
there another way round this please?
Thanks... Sue ...Missing engineering functions
In an earlier version of Excel, I had "engineering
functions" like =dec2hex and =hex2dec. Not, in Excel 2003, I
see them in the "help files' but not in my list of available
formulas. How do I get them to work in Excel 2003?
Thanks in advance,
I don't have Excel 2003, but you should be able to go to
Tools | Add-ins and check mark "Analysis Took Pak" in
the list that appears.
San Francisco, CA
"Geoff" <email@example.com> wrote in message news:zwfIc.299$Qu5.firstname.lastname@example.org...Sheet Function
Is there a function that will give you the sheet name in a cell? (Example:
I would like to write an IF statement that will refer to Sheet Names.
Note: the file must already exist. In other words, the workbook must have
been saved and given a file name.
"Ruan" <email@example.com> wrote in message
> Is there a function that will give you the sheet name in a cell? (E...Office Live
Operating System: Mac OS X 10.6 (Snow Leopard)
Thanks for your help. <br><br>I am trying to use Office Live to collaboratively edit a Word document. Everything works fine until I click on the "edit" button, when I get this error message:"To complete installation of the Office Live Update, close all browser windows and then open your browser again." <br><br>I have restarted the browser (tried both Safari and Firefox) and computer, to no avail. I installed the update for Mac Office 12.2.3, and still no luck. <br...Using percentages #2
I am using percentages to calculate a score of 1 - 5 which updates a
dashboard. I have an average of multiple scores adding up to 100% or less. I
would like to make an input of 0 to remove this column from the average of
example " =average(i7:i16)" if "i8" input is "0", remove "i8" from average
Any suggestions, (thanking you in advance)
Use your formula like this...
Just change the cell reference to your desired cell if required.
If t...Date Function to go back 6 months
I want a query to only pull records going back 6 months from the current
month, how do I do this?
I know I can use a Between but I don't want to have to go in and change the
Dates each month. I just want it to automatically pull everything from
Current Month Back 6 Months.
Any help is greatly appreciated
Message posted via SQLMonster.com
Ok, I think I have it, I used the following:
C.CLOSE_DATE BETWEEN GETDATE() AND GETDATE()-6
Brian Conner wrote:
>I want a query...Problem with named range for a large spreadsheet in Excel 2007
I am trying to generate a large Excel spreadsheet apprx. 10000 rows and 40
columns. I am generating defined name section in the Workbook.xml part of the
XLSM package. Here is a sample entry from that section
<definedName name="_._44802_._0_._0_._0_._top_line" localSheetId="0"
Although the generation goes fine, I can not open the spreadsheet as the
Excel throws an error message saying the package is corrupt. But this is not
the case if the spreadsheet is small say, 200 rows by 10 columns.
...How do I use vbSendMail with this Project?
I have a VB5 project that has a button that I want to click and have the
vbSsendMail form display from which I will send Emails to some customers.
********Sample Code in this VB5 Project below:
Private Sub Load()
Private Sub cmdSendEmail_Click()
MsgBox "Need code here to ""Send an Email"" using vbSendMail"
Private Sub cmdExit_Click()
I have downloaded the vbSendmail.dll and registered it on my computer.
What code do I need to insert in the project above to make I make it happen?
"Denn...Send as permissions using exchange 2003
I have a client who we are trying to configure send as rights for.
Basically if i go into user object > exchange advanced > mailbox rghts >
advanced > add user > edit permissions
I am unable to see the option to send or receive as.
I have tried to enable send as on the object using adsiedit but this does
not seem to translate to being available in the ADUC
If anyone has any ideas please let me know.
As it is, i actually left the permissions applied in adsiedit and after a
while it started working. Still strange tht i cannot see the send as rights