Hi
If data is entered every month in one tab. How would i then sum thi
data by year into another tab?  if necessary i dont want to kee
changing the formula from year to year

I used to have a formula bar, which included a window
showing which cell I was using and the contents of a cell
(formula or numbers). I've lost it. How do I get it back?

After highlighting 4 columns and a variable number of rows,I use thi
formula to give me the 3 highest values in each of the 4 columns(whic
turn pink) under conditional formatting:
Formula is: =C6>=Large(C$6:C$15,3)

Think this is probably an easy question but I just can't seem to figure out
how to do it.
I have 7 columns of data see example below.  I want to compare the data in
each column and come up with a separate list of all the names and how many

A while back, I requested some info and somebody was nice enough to provide
that for me.
What I want to do is to set a filter, and then fill a column, ensuring that
it ONLY fills the records that are showing (visible)!

Hi, I'm using the custom cell format [H]:mm to add times of tasks
entered by remote workers. I want to show a variance from the budgetted
hours which means the answer will sometimes be negative. The cell then
only shows *****. I can't find any way of calculating and displaying a

Is there any way to count the number of characters in an individua
cell?  For example, if I have the word "revenue" in Cell A1, I woul
like Cell B1 to return 7 in cell B1
--

I am trying to get information from one worksheet into anothe
worksheet. I have used the lookup function to do basically the sam
thing all within the same worksheet, and it seems to work fine, bu
when bringing it across worksheets, it doesn't wanna work. Here is th

Is it possible to share out an Excel file and for 2 (or more) people to
access it at the same time with any changes saved as required. A bit like a
database. I'm using Excel XP and Excel 2000.
Thanks

1.I've made a list but the source list appears on the worksheet, how
can I stop this?
2.I also have a worksheet set to be used as a source for list, how ca
I get this source to be used by other sheets/

RE: How do I delete excel checkboxes?
Hi there. I have used checkboxes in a worksheet in excel for clas
atendances. However now I want to get rid of some of them. When I righ
click on the checkboxes it seems to select them. However, when I try t

I would like a particular cell in my spreadsheet to be incremented b
the value of one after I have printed the worksheet.  Any ideas on ho
I can achieve this?
Thanks

I have A1 and A2, A1 has a value of 10, A2 has a value of 5.
What is the formula for A3 to substract A1 from A2?
A3(A1-A2)    ?    anyone?

i have the following information:
a1            ________________   b1
D:john     ________________                
sam         ________________   D:john

When working on a sheet, a big gray page number shows in the middle of the
sheet.  It makes it hard to read some of my numbers.  I don't know how to
get rid of this.  Can someone please help?
Eileen