|
|
OFFSET Formula Question by
Danni2004
Hi
Below is a simple example of my data. The bottom shows a table that pulls
averages from another table above. Could someone help me create an OFFSET...
|
|
4 |
85 |
|
|
Seperating information in a cell by
andyK
What formula can be used to sepearte information in a cell and put into
several cells? I exported infromation contained in a pdf file into Excel. In
one of...
|
|
9 |
82 |
|
|
|
|
5 |
110 |
|
|
Complex formula by
steve
Hi
I need some help,please.
I need a formula to claculate a value when input A and B are inserted. The
table below details the values I am working with and...
|
|
5 |
94 |
|
|
|
|
1 |
94 |
|
|
|
|
3 |
186 |
|
|
|
August 5th, 2008 05:01 PM
by Chris
|
8 |
114 |
|
|
|
|
8 |
91 |
|
|
|
|
3 |
142 |
|
|
|
|
3 |
91 |
|
|
Formula using worksheet names 2 by
E
My original question dates from 31st July, and was helpfully answered.
Unfortunately I am now stuck on a similar problem, which I thought would be
easier. I...
|
August 5th, 2008 04:05 PM
by Pete_UK
|
5 |
91 |
|
|
How to pull in rows based on Column A data? by
Chris Lukowski
I have a need to dump data into a main worksheet and have multiple
supplementary worksheets populate their data based on the value in column A.
Example:...
|
|
2 |
70 |
|
|
Formula using worksheet names by
E
I have several sheets, called say Code 1, Code 2 . . . Code 10, each with a
table culminating in a total budget figure, which is in the same cell on each...
|
|
8 |
88 |
|
|
|
|
2 |
101 |
|
|
Countif - shown blank cell by
Marie
im trying to count the amount of times 'Red', blue, black etc is mentioned in
colounm K in worksheet 1, as i am entering the formula on a summary sheet.
the...
|
August 5th, 2008 12:20 PM
by Wigi
|
1 |
78 |
|
|
|
August 5th, 2008 11:07 AM
by Daniel
|
0 |
72 |
|
|
Logical IF statements by
Matt
When using the IF statement:
IF(logical_test,value_if_true,value_if_false)
Is it possible to reverse the syntax? For example, can =IF(A1=1,"very low")
be...
|
|
3 |
67 |
|
|
|
|
1 |
90 |
|
|
Summing a variable range by
Ram B
I need to create a formula for summing cells say B2 through J2 with results
in A2 so I use the formula
=sum(B2:J2)
As you see I am summing 9 cells.
What I...
|
August 5th, 2008 08:50 AM
by Stefi
|
6 |
77 |
|
|
Excel 2007 lookup problem continuing ... by
Trish
Hi, I posted a question last week and M Kan was helpful. However, I asked
further questions and this person has not responded. Can anyone else help
me?...
|
August 5th, 2008 05:46 AM
by Trish
|
3 |
100 |