I need a formula that can look for a date in
a cell that matchs a date in a range and then enter column letter in the
formula cell
Formula in A1

I have data with numerous col's that can be filtered on.  I've also built
graphs to drive off of this filtered data along with a list on the graph
pulling in what data is being filtered on.  If I go back to my data tab to
clear all filters (menu bar - data/filters/clear all ...

I need to combine two worksheets into one.  The sheets have written
information on them - they are set up in rows/columns- the are formatted
exactly the same.  I do not want to loose the information on any of the
lines, I just want to put all the information together on one ...

How do I calculate the time in hours or days between two fields (startDate
and FinishDate in Date/Time format 8/12/2008 14:41) less weekend and holiday?
Example:
StartDate               FinishDate                      Result

I haven't had any classes in the Vista version of Excel. We got this version
with our Dell about 6 months ago and I'm relying on how well I knew an older
version of Excel at work before I retired almost 3 years ago.
I'm not positively sure how I "unhooked my worksheet window from ...

I am trying to set up a formula where I will need to use for expample D3 in
all formulas, is there a way I can keep that in each formula without having
to enter it each time when I copy the formulas?  
Thanks

Excel2003 ... I have a Col of decimal numbers formatted (.000)
I wish to calculate the "inverse" decimal values for these numbers.
What is the formula or function to do this?
Thanks ... Kha

Given a column of 20 numbers how do you sum the top 5 without having to sort
the column.
Thanks

I need to exclude $$$ amounts from a sumif total based on how many months it
has been in service. Current formulas is: =SUMIF(M4:M23,"JJ",J4:J23) I need
it to scan a different column for how many months and anything over 9 it will
not add to the total. Thanks. V.XIII

Hi!  I'm puzzled...thanks for any help!
I have set up a formula to show a calculated % between parentheses.  Working
great, but now would like to round out result to 1 decimal point.  Since I
think I've converted to text using "", I can't use Excel's normal decimal

I have set the following conditions for my worksheet:
=(TODAY()>=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade red
=(TODAY()>=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade yellow
These conditions are set to each cell in the worksheet.  The problem I

How do i stop the multi-cell selection when I click one cell.  how did it
start and why would it be necessary when I can not control how many cells IT
selects...sometimes two cells many times its 5...enough already...so much
time is wasted.

I am trying to get the character count on a cell.  In the status bar I have
slected count but nothing shows up on the status bar, so i tried them all and
the only ones that show up are the zoom and macro record butoon

When linking two worksheets, all of my blank cells (source worksheet),
display a zero (destination workshhet).  How do I get them to display as
blank cells in the destination worksheet?  I am using Excel 2003 SP3.

I have a three column balance sheet (actual, budget, prior year).  I wanted
to define the names of all of the cells in that balance sheet through the row
and column headings.  What I did to attemp to do this was I highlighted the
balance sheet with my row headings in the far left ...