I need help with a golf tournament spreadsheet.  Golfers are in two
divisions and I can find the lowest raw score and name in each
division.   Not all golfers compete each week, so there are many raw
scores of zero that need to be ignored.  I use named ranges.

I have opened a file in two windows.  I have now saved and closed the file.  
It is not shared.  Someone else trys to open the file but gets the message
that I still have it open.  Unless I completely shutdown excel, the file is
still locked by me.  

I need to create a formula that will search through multiple columns
for different criteria and then give the sum of another column based
upon the search results.  I tried using SUMIF, but it will only search
through one set of criteria.  I need it to search for multiple criteria.

I have a total of funds available of $3000 and tax of 7% and want to find out
what is the highest base price that I could enter and max out at $3000.  
Base number + (Base number X .07) = $3000
I used the trial and error method and came up with $2804.  What formula

I created a chart with 5 little columns.  Excel took the liberty of inserting
a very unnecessary vertical page break.  The information quite easily fit on
one sheet of paper.  Adusting the margins aren't the issue.  Document is
virtually useless to me.

I need a formula that will compare the dates in two cells and IF one date is
before the other, THEN . . . . Can Excel read a date of 12/31/05 and compare
it to 1/15/06, 9/31/05, etc to give me a result?

I'm trying to build a function which counts the number of subscribers
in a list by carrier. Column A has the carriers listed, Column O is
either "Yes" or blank If "Yes", then that address is on the Do Not
Deliver list and the entry should be excluded.I'd have thought I should

I would like to hide the formulas on my spread sheet so that someone using it
would not be able to see them.  is there an easy way to do that?
thanks.
EG

I have a spreadsheet for a large group of students.  It contains many pieces
of data, such as age, race, gender, family members, etc.  How can I get the
data sorted by percentages?  For example, what % of students are Hispanic?  
what % of students are male?  I can do this all by ...

I have a workbook with 2 sheets. I would like to create a relative reference
on the second sheet that refers to a cell on the first sheet, and then use
that reference address to populate cells on the second sheet with relative
references that are offset from the original cell on ...

I have a column of numbers that all need to be 14 digits long.  So I need to
add leading zeros... Currently I am doing =00&A4 and that would be great if
they were all 12 digits (12 + 00 = 14 digits) but some are 7, 8, 9, 10, and
11 digits.  Is there a formula to count the number ...

I'm nesting a function and want to use a wildcard character (which obviously
won't work). The problem is where I have a part of a text string I'm looking
for and it's in a nested IF/AND function that's within a larger function.  
IF(AND(F5="Weekly ~ Sat",A1="*hat")

I would like to combine the sumif function with filters and sum only the data
chosen in the filter.  Subtotal (109,xxx) would ignore the hidden data but I
am having trouble combining the functions sumif & subtotal.  Help much
appreciated.

I have a worksheet that has groups of text in the same cell. I have used
colors to group the text together. I now want to seperate the different
groups (colors) of text to a different cell depending on the color.
Is this possible? Any help would be great.

I've been trying to set up a macro to copy & paste data from an Access Table
to an Excel Worksheet and I cant get it to work.  It fails at the
'ActiveSheet.Paste' stage shown below.
 Cells.Select