I have two worksheets in one document and would like to reference totals from
one worksheet and display the results (by highest total, first) on the second
worksheet.  For example:
Worksheet 1

In column B I have numbers 1 thou 10. In column C I have different dollar
amounts I want a total of all the ones a total of all the twos etc in
separate total cells e.g. 1 is the code for all the money spent on fuel this
month. 2 is the code for all the money spent on office ...

HI, Ive been struggling with this for a while, so i need some help.  I
has to be a simple answer that i cant seem to be grasping, so call m
retarted.  Ok, here goes.....
I have an array on a worksheet that is formatted like so....

I have two columns with text.  I'd like take those rows that contain
multiple "keywords" and put them on a separate sheet.  For example, a few of
the keywords would be: gift, check, personal, error and if that cell
contained any of those keywords then it would be put on a ...

i have a  10 columns of about 100 rows.  I am trying to rank each column.  
example.
column A has 5 rows.  and each row has a number.  I want column B to rank
them.

I'm using the Formula below to sum the count of the numeric value housed in
cell D4 for the month of July.
How can I amend the Formula below to use the MONTH function with a Cell
Reference housing a Custom Date Format: so where I've got  = 7 for July, I

Does anyone know if there is and what is the name for the division funciton
in Excel? I only found MOD, but no DIV in the funtions Excel provides. Thanks!

I need to find the last occurance of text in a range of cells.  The
range can have empty cells and various text values.  This is a project
staff schedule and I want to have a formula that will display the Last
Sick Day and Next Vacation Day.

I would like to be able to type in persons age and have excel place it into
a category.
eg
50 to 59 would be in the 'A' category

is there a way on a time sheet that when i put Holiday or Absent it will the
know that each of the words means 8 hours holiday and 0 hours for Absent on a
time sheet template

Hello, I need to add more than 65536 in a excel worksheet, Do you know
it it is possible?
Many Thanks
Ricy

IN EXCEL, HOW DO I SHOW A CELL THAT IS EMPTY AS HAVING IT FILLED WITH SPACES
AND HAVING A PARTICULAR LENGTH (FOR EXAMPLE 35).  I NEED THIS FOR A CLIPBOARD
AND IF THE DOESN'T COUNT THE SPACES, IT THROWS OFF THE POSITION OF THE NEXT
CELL

Hello, I have a spreadsheet with multiple sheets, and want to prevent
people from seeing my formulas by protected the sheets.  However, I
have data "grouped."  If I protect the sheet, people can't click on the
"+" to expand groupings.  How do I accomplish both?

I need to perform the following function:
compare column a in sheet1 with column a in sheet2,
if there is a match then I want to pull the values from sheet 1 column b and
c to

I have a function to convert date of birth to # of months old as of today,
but need the function to convert date of birth to # of months old in 30 days,
in 60 days, in 90 days, etd.