Can someone explain this formula to me?  
=$C$36/$B$6

I have recently set up three Excel spreadsheets for formatting data imported
from a text file generated in a DOS program.  Once the data is pasted into
the master spreadsheet it is renamed with a date and a set of two or three
macros that manipulate the data, inserting/hiding ...

I need to calculate standard deviation for data located on multiple
worksheets. The problem is that the number of worksheets changes from time to
time. I want the calculation to automatically adjust to include data from the
third worksheet up however many worksheets there are in ...

I have inherited a spreadsheet that has the following formula:
=SUM(B6:O6)-SumByColorFont(B6:O6,$U$4)
The person who created this is not accessible and I can not find anything in
help regarding the SumByColorFont portion of this formula.  Does anyone know

I have this data. The 17894 in the last row( C17) is the max of C3:F16. That
value is located in D16. Is there a way that I can have a cell produce these
results  -
the # in row 2 ( 101,102, 103 or 104), and the day and date in the A & B

I have a table like this. I would like to format the cells so that for each
row, greatest value is Green and smallest value is Red. For example, for the
first row, %90.68% would be Green, and -28.34% would be Red.
Is this possible ? Thank you in advance.

is there any way to make A2 in the formula a function of a cell value?
=VLOOKUP($B$1,A2:D1969,3,FALSE)
Example: if  F1 = the value of: "A50"
So the formula  in A1 would be:

The first worksheet in my spreadsheet contains all of the data that I've
entered.  I would like to create additional tabs that pull specific bits of
data out -- based upon inidivudal columns in the first spreadsheet (role
group, event name, etc.)  Is there any easy way to do ...

Is it possible to do this, have two worksheets one with Summary data and one
with Detail data have the Summary sheet constantly look at the Detail sheet
and if there has been new data entered on the Detail sheet automatically
enter it on the Summary sheet. I have sales orders ...

Im hoping someone could show me how to code this.  How do I copy a
worksheet x number of times? The user will have to enter then number
in a cell and upon cell selection change, I want Excel to
automatically copy the worksheet.

I'm averaging a list of numbers and want to assign a value based on that
number. For example, the average is 45. I want a cell to display a character
based on the average. If the average is between 40 and 49, the value is B. If
the average is between 50 and 59, the average is A. ...

Ok, I have a question about my formula in excel.
=if(b1<>1,match(a1,a2:a$300,0),"ok")
b1 is a cell that I've used countif in. In this specific case, I'll either
have 1, or 2 as my values.

Hello, I am trying to do a look up, to look at a cell I have entered a row
number in from a previous sheet.  That row number relates to a certain entry
of about 4 columns.  I would like to have 4 cells do the look up to relate to
a particular entry for the row I have entered in ...

i have data that looks like the following:
2   7
1   5
2   7

How to use Ara and ARP fucntions on Ms Excel?  Please help me in this regard!