Is there a function that will return the date of the last refresh?
I have a spreadsheet that with many users.  It would be helpful if the user
could tell when the last refresh occured to know whether they need to refresh
the data before using it.

I'm trying to use a cell reference in a COUNTIF statement:
=COUNTIF(C:C,">"&G1)
For some reason I can't make the formula work.  According all I've read,
this is the syntax that I should use.

I essentially want to perform a vlookup of the second (not top) lookup value
in an array.  So if I have the following data set:
1    A    100
2    B    78

I have an Excel spreadsheet that I want to add option buttons to, so that
when the word Yes is selected it will have the value 2 and No have the value
1.  Also, if I have Yes option in Column I Row 12 and No in Column J Row 12,
then under that have a Yes/No option, how can I have ...

I want to calculate the number of months between two dates that show in the
format, 11-Jan-07.
HELP Please!

Is there a way to apply multiple passwords to a workbook that would allow the
workbook to be shared but users limited to what they can see in the workbook?

I need to show a total for a series of values.
Some of these values may be replaced with "N/A" as a result of an IF formula.
When this happens, the total does not always calculate, which has a knock-on
effect for other formulas.

I'm getting an odd result with 2 variable data tables in a complex
spreadsheet - only the 1st (top left) cell returns the proper value, the rest
are either zero (or Div/0! errors if I try to return a percentage result).  
The data table evaluates the result of a very complex ...

หนึ่งพันสองร้อยสามสิบสี่บาทถ้วน
when i use this function it will display the above code.
i can't get the result.(bahttext(1234).
regards,

How do I create a spreadsheet with alternating colors by column and by row.  
Ex: I want the rows to be green and white by line to make it easier to read.  
But I also want columns H-O alternate a different color lengthwise.   I was
able to get the rows to alternate colors but ...

I have a cell conditional formatted as red or green depending on the value.
I have a text box on another sheet referring to that cell.
Can the text box contain the same conditional formatting ?
And if so, how do I do it ?

I have an excel spreadsheet that has the following columns:
Customer ID    Price    Item                Price        Price          Price
                     Level    ID                   Level 1      Level 2    
Level 3

I have a list of activity IDs that I need to add a number or a letter before
a period (.) Here's examples:
Orig Activity ID          
1.1.1.2

1st worksheet;
fill in form      cell A1= inches_____
                       cell A2=gallons_____
2nd worksheet=lookup sheet

How can you combine a symbol and a formula into one?
I have a coloured square (a symbol or a drawing) I want to put in
front of a formula. I have tried combining with '&' but without luck.
I does put the symbol in front but not as the square. It shows