Currently Cell 'B4' in my worksheet contains the following formula. Now this
formula WORKS. I just want to refine it a tad more. Currently, if cells
AE4,AF4,and AG4 contain and error, then B4 is blank. BUT, if AE4, AF4, and
AG4 are blank, then B$ shows a "0". Which is correct. I ...

When I click, with mouse, it sometimes selects more than one cell, usually
2/3 cells below as well.
How do I stop it doing this?

How can I use MATCH to find the next highest value when there isn't exact
match.
E.g
1-Jan-08

I need assistance trying to use the Offset funtion with a formula I had
already created.
Current formula:
=IFERROR(SUM(Data!J3:J39)/SUM(Data!I3:I39), )

I have a simple spreadsheet that lists credits/debits and balance in 3 columns
I want to have a running total in the balance column.
How can I keep the formula for each cell but not show it as say £0.00, until
it is actually populated with valid data

The contents of cell P8 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID
logs\RAID log.xls reads "Not Required".
The contenst of cell P8 on sheet("Issues") in T:\Storage\1.Reporting\DB\RAID
log.xls reads "='T:\Storage\1.Reporting\DB\RAID log\[RAID Log.xls]Issues'!P8",

I have a spreadsheet which calculates school term bills for children
attending a before and after school club dependent on their attendance
patterns. It also records payments which may be regular or intermittent and
calculates the amounts owed.

I have created sub-totals on a worksheet, but for some reason the outline
that typically shows up is not working.  The sub-total lines were inserted,
but the grouping did not.  Is this a set-up or a program issue?

I would like to sort automatically (not manually) the values in 10 different
cells and when the values change the order of the cells automatically
change.....and so on…
Do this manually is no worries but….automatically…?

The formula written as =IF('Boiler 3'!$M$15<>"",'Boiler 3'!$M$15,"") does not
display the result in the cell even after switching the sheet between formula
and value (ctrl `).  This same formula works in other areas of the same
worksheet.

Hi - Can someone help please?
I have a worksheet where a column adds 2 years to another column to auto
calculate a renewal period - is there any way to set excel up so that when
this date is reached an email or notification is sent to a specific

Is there a way to automatically sort a column in ascending order while
entering numbers so that the column is sorted when last number is entered.
Appreciate all help.

A client of mine imports data into Excel 2003 from an external system.  The
numbers vary in length when imported, never more than 6 characters long.  The
client always need the numbers to be 8 characters, is there a way to add
zeros to the start of the number to make it 8 ...

Hi - i have a job to do and i have 30 days (cells) and a number - eks 200 -
i want to spread out sporadic numbers in the 30 cells and the summary must
be 200.I know you proffesionals out there can tell me!
I`ll be pleased

How can I recognize the first 2 letters in a cell using formulas? I want to
be able to recognize cells which contain certain initials from employees.
Example would be if C1=SS Glass, C2=AF Metal and C3=SS Paper, I need to know
that SS had 2 entries.