Hi, I am facing a problem with the Validation problem. I am two excel file
names "A" n "B". Currently I am using Validation command in file "A" to list
the items in file "B".
Once the procedures are done and I pressed the "Down arrow" button in file

I have been trying (unsuccessfully, so far) to figure out how to write
syntax to check for missing data in two cells before executing a function.  
For example, I know that I can write:
“=IF(D9>0, D9-C8)”

I'm trying to figure out the formula to sum values in column B that have a
certain range of dates listed in column A and also have a particular value in
column D.  Here's the spreadsheet.  
    A . . . . B . . . . . . E

I believe that I want to use something like this but it doesn't seem to work:
=IF(CC7>0,1,0)
I have also tried:   =IF(CC7<>"",1,0)
If the value in CC7 is greater than 0 then place the number 1 in the cell

My problem is that I import a table with a number of columns (using "New web
query"), one of which (D) is a column of dates in the form "08  July 2007"
(two spaces between the number and month as it happens).  In Import External
Data - Options I am forced to select Disable Date ...

Column A of my spreadsheet has several amounts formatted in either US$,
Pound Sterling, Euro, Swedish Krona, or Swiss Franc.  (I used the Format ->
Number -> Currency -> Symbol for each amount.  I am actually using the
currency symbol rather than the ISO abbreviation for each ...

have a macro that I keep getting a error on. Can anyone help.
The macro shown below.
Sub Macro2()
'

Excel 2003
I'm trying to do a simple countif. In column A, I have...
A
010020

If I have:
Apple     Lemon    Orange
3              0             1
How do I get Excel to look through the row of data, find the minimum (or

I have on spreadsheet that has a column with a list of single numbers or
letters the next column are times associated with those numbers and letters.
I want to type in one of those numbers or letters and have it displayed in
another worksheet the time associted with it. I have it ...

In Excel 2000 and Excel 2003, I am trying to validate if specific (x,y)
coordinates fall within the area bounded by 4 intersecting curves with
equations "y=f(x)", and am looking for help to set this up. I have tried the
normal logic of IF, AND, and OR, but have not been ...

I have the a number in A1 312.  I want to find that number in column K
and enter the corresponding text in column L  into cell A2.  How do I
do that?

I have a large spreadsheet over several pages and i am crossreferencing the
pages.
I want to point to a cell on a previous sheets which i  can do but!!! i have
about 70 rows to do this on and wonder if there is anyway of copying the

I am looking for a way to reference a cell to define a function range.  That
is the standard function   =AVERAGE(L3:L20)     I would like to have the 3
and the 20 sourced from other cells.  The goal is to be able to change all
the average ranges in a spreadsheet by changing just ...

I wish to shade to grey, or change to white, cells in a chart from G8 to BR28
relative to variable information in columns B and D and compared to preset
values in row 7. I don't believe that this code can be within the cell as the
user will be entering text there at some other time. ...