I have a large column of numbers that totals $110,555.  I need to find out
which numbers total approximately $57,622.  Is there a function that can take
a range and select items that total a specific number in the range?

Is there a way of returning the largest letter in a series of cells with
letters in it for example Cell 1 = A, Cell 2 = B, Cell 3 = C, Cell 4 = D the
formula would return 'D'
Please help

I need to remove the first 9 chracters in every cell of column A of m
spreadsheet. What's the best way to do that?
My spreadsheet is currently huge, lots of data, graphs, functions an
defined names, all of which make it quite slow to load and manipulate

is there a way to lock a worksheet so that all you can do is input data in
certain cells.  i know about protection and locked and unlocked cells but you
can still copy, cut,paste and change formatting in unlocked cells.  i want to
lock it tight

I want to combine the information in two worksheets into one, matching to an
ID number.  For example, on one sheet I have name, ID, date of birth.  On the
other I have ID, street address and salary.  I want to combine the data into
one worksheet by matching the ID.

I have the following data:
Code
-------------------
   22/03/2006 0:10

I have the following data in a worksheet
A           B                                                  C
MT00926    O.HEAD MATHS DISCOVERIES SET 2    154
MT01381    GRAPHING MAT & BOOK SET                42

Using Excel 2003 I want to make a button control visible/invisible according
to the value in a cell which contains the formula counta(a1:a10). How can I
do this?

Sheet1
Column A
"This is my string1"
This is my string2

Hi , Could anyone help me
I am looking for the conditional formatting code that will change the
colour of a value in a cell if another cell contains the text A. I
would then want the formatting to work as a dynamic reference

I have a problem with the today Function. It appears that it change
each day.
But that isn't what I want! I'd like to have a funtion that puts th
current Date in a field when Data is being added in the Row and the

I have the following data:
Code
-------------------
   22/03/2006 0:10

How do I use the SMALL command when I want it to look at values liste
on different sheets? The problem is that it won't let me list more tha
one array like the minimum command allows me. Or is there some way t
list cell numbers inside a bracketed array instead of values? Fo

Is there a function to count blanks in a filtered column?  That is, i
I filter a column to show the rows that are blank, can I use th
subtotal function (or some other) to count the number of blanks?
Thanks,

I have a worksheet that is Plan calculator for customer of a teleco
company. There are four sheets,
sheet 1 Instructions (Instructions given how to put data and ge
result)