Is there an Excel function where you can select a group of cells (with dollar
amounts) and find out which of the cells total up to a partiular amount?  
Example, if you have a check for $82,067.91 and there are 40 rows of figures,
and you need to know which figures total up to the ...

Is there a way to format a cell say to currency using some function?
yaro

Is it possible to colour the background of a cell depending on the
result of a formula? Example: If the result is "Within Limits", colour
the cell in green. If the result is "Outside of Limits", colour the
cell in red.

I need to create a formula that compares 2 amounts in cells C9 and E9.
If the difference between the 2 amounts is equal to or greater than
1000000 (1 million), then the answer to my question is "Yes".
Otherwise, it's no. I got this far:

I have to do a time sheet with 10 people on it, some work night and some work
days.The days are no problems but when it come to the night shift they start
at 1800 and finish the next day at 0600. I need a formula that will be able
to do both as they rotate between nights and days ...

I have an excel sheet with hire dates in one column and I need a formula that
will return the same month and day as the hire date but with the current
year.  Any ideas?

I need to set up a function if possible to display what the date will be 24
days later. I need to spread out my reviews to be every 24 days - I would
like to know the dates. Help?

I am wanting to sum up data in a column only when it corresponds to data in
2 other columns, i.e.
Stage          Person          Cost
Stage A       Person  1      £5

Hello. Apologies if this is an old problem.
I'm using DCOUNT to count a subset of records in a table, and it's doing
exactly what I want, but now I want to count only the records with a unique
value in one of the columns. Like -

We have developed a customizd macro where we are sorting more than 5000 rows.
For a particular selection, the current region range is not getting selected
and macro is throwing "Range class failed" error while sorting.
This issue is not coming in Excel 2007.  

for some reason, i cannot break a link of which i no longer use. i
have attempted to remove / break the link, but so far, unable to do so
is it possible for someone to attempt to break the link for me?
once done, i plan to distribute this worksheet publically for anyone

I have 100 plus sheets in a workbook.
Each has the same layout for data entry.
Each sheet tab is the name of an employee.
In (B1:B10) I enter a date.

Hi, I hope someone can help me, several of you helped me with this problem
earlier and I am finding however that the following formula does not update?
Rolls!A4 contains the following formula
=INDIRECT((VLOOKUP(B2,D41:F50,3,TRUE))&"!A5")

I have created a formula to determine the min value (field A) and the max
value (field B).
I then use the Concatenate fucntionality to show the range like this:
=Concatentate(Field A,"-",Field B)

I'm trying to put together a simple schedule in Excel and need to calculate
x working days from a given date.  So if cell A1 = the project start date,
and I need the date in B1 to show the completion date of 13 working days
later, is it possible to do that without having to have ...