I have 2 worksheets - Sheet1 contains a list of ID numbers in column A,
contact names in column B.  Sheet2 contains a list of ID numbers - some
of which will match those in Sheet1, with email address next to them.
I want to create a formula for Sheet1 which will look at the ID ...

I’m trying to understand how the various sumif and sumproduct functions
work, because I want to sum up data based format of the cell containing
the data.
Please note that I'm using EXCEL97 with all of the latest Microsoft

I am trying to delete sheets but the option is grayed out.

I wish to convert the number value in one cell to text in another
e.g.
£123.56  One hundred and twentythree pounds fiftysix pence

I have a summary sheet with a list box that pulls data from several sheets. I
have about 30-40 names in this list box. Instead of selecting the name 30-40
times from the list box, is there a way to click once and print the data for
all this 40 names.

if the names given are
peter alan smith
geroge w bush
william scott scotty

I have a very large spreadsheet.
I have created 2 new worksheets within this workbook - SAME and DIFF
I would like to compare columns E and F in worksheet RAW,
 if E=F, then take the whole row (format and all) and copy to SAME

I currently have a cell that has the folowing formula  
=SUMIF(B13:B28,10,P13:P28)
Is there a way for this cell to allow a manually input value and if none
then utilize the above formula for an automatic cell value?  

Dynamic Named Range "Results" spans 6 Columns and many Rows - starts at Row 2,
headings in Row 1.
One cell houses 6 Alpha-Numeric single-digit (entered with leading zero) or
double-digit values entered like 08-20-21-40-60-61 per row. Each value will

Can anyone tell me how I can look up the "minimum but one" in a range of
cells??
There must be a way
Thanks in advance

Hi all - I'm not sure if it's an IF statement I need - but if it is the
I would like to know how to ignore cells with zero as the number.
Let me explain further:
A                       B            C             D      

Probbably very basic but just cannot think grateful for any help.
How do i test using a built in formula if a column is blank ie it has no
text or numbers in it.  I can do it using code etc but would like to use a
formula

I have a column containing multiple occurrences of a string. I can use
function
=MATCH("?.2";Sheet1!A:A;0) to find the row number of the First occurrence,
but I need row No's of ALL occurences (in an array?) because I'd like to

I have a work sheet with alot of columns with each having a different header
subject. Each column has hundreds of rows of data. How do I set a page break
where the headers for the columns will appear on each page. Also if I delete
a row it will automaticly bump the next row up ...

I am trying to write a sheet where people will send in a form to sign up
(name, address, phone #, etc.).  However, when it gets compiled to
submit, all contact must be printed in alphabetic order based on last
name.  I know that I can manually choose >> DATA  >> SORT.  This is