I have a worksheet in which I want to write a formula that will look in a
column of 5 rows and return to me the first date that is posted in that
column.
My column of cells consist of Cells C12, C13, C14, C15, and C16.  This

tHi All,
Is there a keyboard shorcut for entering a Σ symbol, e.g. Alt+????
Regards,
Stefi

I am trying to create a formula that will assign a letter to a cell depending
on the amount in the cell next to where the letter will end up.
In the numbers below if 2.0 is in cell C5 I want to assign cell D5 an A. If
1.3 is in cell C6, I want to assign a B to cell D6.  My formula ...

I am using a table w/ the following data in columns A - C:
Prospect Name    Week Created    Status
1                                       11/6/06           Open
2                                       11/6/06           Open

Can I export my queries into a preformatted Excel Template? I ave tried all
day with little results. I have three seprate queries. I use the transfer
spreadsheet and the range in Access. But for some resons I cant get Excel to
hold all the formatting and basic Sumarry of my ...

I would like to sort a box of data by one cell in each box, rearranging the
boxes while keeping the data in each individual cell intact.
In the example below, I would like to sort the boxes (imagine lines around
each company) by the difference in the salaries betweern President ...

Have data that is supposed to be dates, e.g., 06-29-06, that has been
formatted with a custom number format of 00-00-00. I need to convert it/them
to actual dates; however, the number is really 62906, which converts to
03/23/72, not 06/29/06.  Help!  and THANKS!!

Problem: I have a drop down list in Cell A1 which lists our 10 store
numbers. The user must select their store number and I want cell A2 to
Automatically fill in the Store's Address, instead of the User typing it
manually. (This is to avoid spelling errors because this cell is ...

I would like to sort record A1that has A2,A3 ,A4 rows attached . How do I do
this and keep the records together if I have 50+ record to sort

I have a spreadsheet where one of the columns displays a code (ex: VA, , CN,
VF, VV,...)
I need to display in a new column the group of these codes.
ex:

What is the proper syntax for using AND and OR together in the same
statement? I want to say IF C2=x1 OR c2=x2 OR c2=x3 OR c2=x4, AND c4=y1 OR
c4=y2 OR c4=y3, THEN, ELSE. I can't seem to get it right. Help, please.
Thanks in advance.

I am or have been attempting to extract data from a pivot table.  I would
like to use a reference in "sheet 1" cell $A1 as the "item" in the
getpivotdata (the pivot table is in a separate sheet) formula below.
=GETPIVOTDATA("3Q06",$A$3,"Linking - Building code","11")

I have a macro that opens another spreadsheet (spreadsheet B).  
This second spreadsheet is named: "Projections 2006".
I create a var called WB2 which contains the name of this spreadsheet:
 WB2 = ActiveWorkbook.Name

Hi....
I'm attempting to do a backwards search, but I keep getting a mismatch
error on the Find function and don't know why.
      Range("AH5").Value = Range("H3").Value

I need to add/subtract cells together in a very large spreadsheet, and one
column that I am working with came out as all negative numbers, s there any
way to add something into my sum function so that I can make the numbers
potivie?