I've tried this and tried this and just can't work out how to do it.
And advice would be hugely appreciated.
Is there an easy way of having the following decided in a single cell:
K16 contains age, rangename cltage

I am trying to do a Vlookup on some activity dates. My formula is
=VLOOKUP(O14,Sheet2!$A$2:$L$12804,9) where the value is an activity ID and
the index column is the finish date which is in date format. However the date
that I get from the VLOOKUP is not the same date as in the ...

I lost the previous reply.  I am putting a data base together using Excel.  
Can it be exported to Outlook and Outlook Express ?  Any special column
headings to avoid or use?
thanks

I'm not a 100% newb to Excel, I've used it for some pretty basic stuff in the
past.
I'm trying to set up a basic tournment reporting for monthly card games some
buddies and I have going on. I'd like the players tab to refer to the

Hi,
In my spreadsheet I would like to highlight 3+ text values in bold and
different colours. E.g. New = green/bold, Modify =blue/bold, Delete =
red/bold, Undecided = yellow/bold.

I have set up an excel workbook and attached permissions to gain access to
change or add data to cells without the password.
My question is : Can the password be cracked even though the user does not
have permission to edit or change the cells.

hi community
how can i create a range name that can be use within 2 worksheets,
example
in worksheet 1, i have range from A1:A3 and name that as "Fruits"

I have spreadsheet with the following:
F3 = $175
This formula
=SUMPRODUCT(--(C$51:AJ$51=B41),--(C41:AJ41>0))*F$3

I have a subtotal, that shows all the items in the subtotal. For example,
there are 4 salespeople with 10 to 30 accts each. So far, looks fine ...but...
I would,like to just drill down a bit further and show just the salesperson
name and the number of accrs they have.

I have a master spreadsheet that changes everytime it is updated, and it
contains 5 columns of information. In a new spreadsheet i want to be able to
search for one column for a specific bit of information, and when found it
will copy the whole row of information ? Is this ...

I want to print text from cells to a pre-designed/printed form. I have
duplicated a pre-designed form in a worksheet but now want to print just the
text in the cells to the pre-designed form hard copy.

All of a sudden my worksheet will not input dcecimals automatically...i.e

1000.00. Anyone know how to stop this. No matter whether I format the column
or just the cell it compresses the number.

I would like a simple text box or message to appear when a spreadsheet is
first opened that will require the user to push OK.
What I actually want is a box to pop up as sson as the spreadsheet is opened
that says "Only enter data in cells that are color coded Tan!" I would like

Here's what I have:  Spreadsheet with column of currency that was formatted
as "text".  I inserted a column to the right - put in formula =" "&A1 and the
numbers then appears as numbers (without the little green tab in the corner).
Then I wanted to delete the first column but ...

I really love the new AverageIF function in Excel 2007, however, it doesn't
work for me :(.
When I use a cell reference as criteria, I get a div/0 error. If I change
the cell reference by the value that is in that cell, the function works.