problem with index formula
The following fomula is contained in cell C16 and returns the correct
The following formula is contained in cell L18 and uses the result in
C16 as a lookup value in the first "match":
My promlem is that when I try to match on cell C16 my index formula
returns an error. However, when I change the index formula to
reference another cell (let's say cell D16) and I type in the value
shown in cell C16, the index formula works fine. I think my problem
has ...Delete table values automatically
I want to create a routine that will clean all records from a specific table
automatically once a week (if possible) or each time that the MDB opens up.
Thanks a lot in advance
the code to empty a table is simple
Public Sub EmptyTable()
Dim strSQL as String
Dim db as DAO.Database
Set db = dbengine(0)(0)
strSQL = "DELETE FROM TableName"
db.Execute strSQL, dbFailOnError
Set db = Nothing
the above code goes in a standard module
when your database opens, you call the routine EmptyTable
"Lp12" <Lp12@discussion...How do I display a formula calculation in plot area of a chart?
I want to add a text box in the chart that returns the value from a formula
that was entered on the data page. The formula value is not related to any
You need to build your text expression in a cell, then insert that
expression to the chart.
First, to build your text expression:
1. Select your cell
2. Enter = first to let Excel =know you are adding a formula
3. You can now enter text within quotes and cell values .. here's an
=" Yesterdays average temperature was " & sheet1!$a$3
Note that the & is used to add ...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...The value become wrong when get value by using AppleScript while other worksheet is active.
Operating System: Mac OS X 10.5 (Leopard)
I just want to send a bug report.
The value become wrong when get value by using AppleScript while other worksheet is active.
1. Create an AppleScript file with below script.
tell application "Microsoft Excel"
set OriginalWorkbook to workbook "Workbook1"
set OriginalData to string value of column 1 of row 1 of worksheet 1 of OriginalWorkbook
2. Launch Excel 2008 and create a Workbook called "Workbook1".
3. Enter time data "11...Choose highest value in a row
How do I tell excel to choose the highest value in a range of cells?
A B C D E Highest
1 3 2 7 5 7
will return the highest value.
> How do I tell excel to choose the highest value in a range of cells?
> A B C D E Highest
> 1 3 2 7 5 7
> help please.
=MAX(A1:E1) returns 7 in your example.
Gord Dibben MS Excel MVP
On 23 Oct 2006 10:47:09 -0700, email@example.com wrote:
>How do I tell excel to choose the highest valu...Report generated from text box fields
i have a 3 column report. The 3 products compared on the report are assigned
when the report opens and asks the user for the ID..
is there are way to create 3 unbound text fields and have the report compare
the IDs of the products listed in the text box..
i have done something similar that searches based on what was entered in a
text box, but wasnt sure how to have the report pick up three different text
this is an example of what i have in another application that opens up a
Like "*" & [forms]![SEARCHMENU]![text37] & "*"
Message po...Need to separate multiple numbers in one cell
I have multiple number in one cell and i need to somehow put each number into one separate cell for each number:
I have :
row1 2 5 8 10
column B column C column D column E
row1 2 5 8 10
How do I do it on Excel 2007?
EggHeadCafe - Software Developer Portal of Choice
Map Stored Procedure Output To Class Properties
Use Data > Text to columns and specify the delimiter as space
...Need Formula to Average Monthly Increase
I have a spreadsheet where there are columns for each month of the year
Each cell contains a number of loan submissions that graduall
increases per month as we gain more business from each mortgage vendor
I need a formula that can look at multiple cells in a row (i.e
Jan-Dec) per vendor and then give me a result that shows the averag
monthly percentage increase factor in submissions...
MONTH Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
A SUBS 1 5 18 29 30 40 57 85 150 275
..I will be using this data fo forecasting future submissions ...Going Back in History formula?
How can I express a formula that would back 300 rows and look at every
other row for the 3 cells with random single digits from 0 to 9 and
calculate, the how many rows back since the oldest 0-9 digit occurred
in cell 1 answer, cell 2 answer and 3 answer, then calculate which 0-9
digit has not occurred in cell 1, cell 2 and cell 3 the longest and
displays how many row back since the last occurrence.
So that would be 4 separate formulas
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.Exc...How do I enter a time formula into a worksheet that determines if.
How do I, set about entering a formula within a worksheet that determines if
the Time is greater or less that the time in a certian cell;
eg =if(now()>K17,"then display this","") K17 holding the Value 08:30 AM
formated to time
=IF(MOD(NOW(),1)>K17,"then display this","")
>How do I, set about entering a formula within a
worksheet that determines if
>the Time is greater or less that the time in a certian
>eg =if(now()>K17,"then display this","") ...Existing formula
I'm working with a spreadsheet that was built by someone else and cam
across a formula in some of the cells that I'm puzzled by. The formul
begins with "=", but the next character is "+", then a reference t
another worksheet and cell. The "+" is what I'm wondering about,
haven't seen it used in this context before, can someone help me ou
here? Some examples of what I'm looking at are:
Message posted from http://www.ExcelForum.com
It's an unnecessary character that is there because the person ...copy value in cell above to cell below for a whole column
I have a spreadsheet that was saved from a report. this report only lists
the employee name once. There is a way to copy the value of the cell above
to the cell below. I can get as far as highlighting the blank cells with the
Go To function, then I can not remember the steps to tell excel to copy the
data into the blank cells.
Can anyone help?
Ctrl+D will copydown the value of the top cell to the highlighted cells below.
> I have a spreadsheet that was saved from a report. this report only lists
> the employee name once. There is a way to copy th...formulas changing when emailed
At work, I have created a spreadsheet that has links to workbooks in a
user drive..called the "U: drive."
When I transfer this excel project to others via email, I make sure
that the other workbooks also have the same name in their U: drive as
However, whenever I email it... I have to change many of the formulas
at their computers bc the references in my formulas change to a really
I have tried using "CNTL+H" to replace the "=" to a "+" but it doesn't
work for me bc I have "+" "=" elsewhere in my formulas....CRM 4.0
We have just made a migration from CRM 3.0 to 4.0, and everything went
well, except one thing - field Resources is disabled (like it's in read-only
mode, but it's not!), and we can't find the way to enable it... Any
Best regards, Ivica
I'm sure this is a bug - we had it on the fax entity with "to" - Team
please take note
I modifed the xml - after i look ed at a clean xml to see the diffence
"Ivica Ivancic" <firstname.lastname@example.org> wrote in message
news:5534F8F2-930B-45F1-A503-4D4DBA092E0F@microsoft.com....Validation Rule for IBAN Account number in MS Access Form field
In my table (and the form field linked to it) I have a field for the IBAN
account number, which must be 2 Upper case characters A to Z, followed by 18
manadatory digits, and up to 28 total.
So in my input mask I have this:
and it works fine.
But when the user enters less than 20 characters total (including the two
letters at the start and at least 18 digits) Access gives a very unfriendly
''The value you entered isn't appropriate for the input mask
'>LL00\-0000\-0000\-0000\-0000\-9999\-9999;;' specified for thi...Need mm-dd-yy for date but helpless
I am from India and by default, Vista accords dd-mm-yy for short dates,
which is creating problem in Excel. I tried to look for options but in
Vista, Regional settings, there is just no setting for having mm-dd-yy. What
should I do?
"Ghitorni" <email@example.com> wrote:
>I am from India and by default, Vista accords dd-mm-yy for short dates,
>which is creating problem in Excel. I tried to look for options but in
>Vista, Regional settings, there is just no setting for having mm-dd-yy. What
>should I do?
I don't have Vista in front of me, ...How to add customer's totalSales without transaction?
Some customers transaction record are lost. I only have their totalSales. Now
I want to add these customers to rms with their totalSales. How can I do it?
> Some customers transaction record are lost. I only have their totalSales. Now
> I want to add these customers to rms with their totalSales. How can I do it?
You can add the customers and their totalSales only from QS
Administrator with SQL query..
UPDATE Customer SET TotalSales = <AMOUNT> WHERE AccountNumber =
Can anyone suggest good add-ins that support CHAID and CART clustering
...How to Add Streaming Video To Your Website 04-15-09
...Add E-mail Account
I am completely new at this and I need some help!
I am trying to add an email account to Outlook. Our company uses SBC Global.
I go to Accounts and click add and follow the steps. But it doesn't seem to
Can anyone help me?!
Did you check how others in your office have their email accounts set up? You
can also check the SBC Global website to see how they advise you to set it up
(server names, etc.).
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
> I am completely new a...Outlook 2003, I need a few clarifications
I recently installed outlook 2003.
Then I had to reinstall windows shortly after, but luckily I had made a
backup of all my .pst files.
But now im suddenly all confused over what those different .pst files are.
outlook.pst seems to be my main-one with "private/personal folders" (it
also contains my calendar notes).
But then i also have a archive.pst (thats twice as big in size as the
outlook.pst). Anyone know what that is? Do i even need it?
Lastly i have some hotmail .pst files, and they don't seem to be recognized
(when i put them in that dir where outlook looks for ....Need to up date refereences from Ofice 2002 to 2007
I had vs2008 and Office 2000 or maybe 2002 installed.
I rebuilt my system and installed Office 2007 instead.
Now when I try to compile I get the errors shown below.
I guess I need to add a couple of references and do see many for Office but
can't identify the ones I need.
I also hav a sneaking suppesion it's not that simple.
Can you help get this fixes?
Warning 1 The referenced component 'Microsoft.Office.Core' could not be
Warning 2 The referenced component 'Microsoft.Office.Interop.Word' could not
Warning 3 The referenced...Excel 2003 - VBA
I'm drawing a blank and need some help.
I have a table with row 3 containing sheet names (currently pointing at 106
In rows 4-250 I want to put formulas that will look for something (located
in Column B) in each of the sheets named in row 3. The first cell in the
target sheet contains the last row with valid data.
Cell "D3" = P02-05
Cell "B5" = 123456789IBM
In cell "D5" I want to generate a formula that will look in sheet P02-05,
search for the contents of "B5" throughout the sheet and return the Value in
colum...How do make my logo's background (the actual page) transparent?
I've read the instructions on how to make a background transparent. So the
background of my text box is transparent. But when I paste it on a colored
background in Power Point, it's still white. I guess this is because the
actual Publisher page background is white. Can someone help please? Thanks,
Highlight the text, not the box, copy
Paste special, unformatted text.
Mary Sauer MSFT MVP
"WordSmooth" <WordSmooth@discussions.microsoft.com> wrote in message