|
|
Working an If formula by
Daleen
I have 4 columns that I am concerned with. Say F6 is a fixed number, column
G & H are Yes and No columns. Column I6 could change. I want my formula to
see...
|
August 29th, 2008 04:04 PM
by Daleen
|
9 |
83 |
|
|
count instance by
Brad
Thanks for taking the time to read my question.
I have a list of computer models and I'd like to have totals at the bottom
of each kind using a formula.
...
|
August 29th, 2008 04:02 PM
by Brad
|
3 |
80 |
|
|
|
August 29th, 2008 03:26 PM
by Mark
|
3 |
107 |
|
|
too many cell formats by
Gene[_7_]
Does anyone know how to correct this error short of reformatting and
starting over?
|
|
1 |
100 |
|
|
Add cell "50+55+50+50" to give answer 205 by
shyboy2k
I have a cell where I need to keep the amounts separate to show workings
out, but I need this to be then added up in a sum, is there a way to do this
as at...
|
August 29th, 2008 02:45 PM
by PCLIVE
|
9 |
216 |
|
|
Creating pivot table to Existing worksheet by
Malvaro[_8_]
Here's all the relevant information:
a) I was able to successfully create a pivot table, in a newly created
tab named "Sheet2". This pivot table is contained...
|
|
1 |
96 |
|
|
Vlookup on Dates by
LossManiac
I have a table containg start dates in column a and end dates in column b.
The start date for the second (and subsequent) record is the end date for the...
|
|
6 |
153 |
|
|
|
August 29th, 2008 02:18 PM
by Joe L
|
2 |
119 |
|
|
Using excel as a database by
Miree
I have an excel sheet used for entering data, I am now hoping to expand the
sheet to use as a database so everytime i add a new result i can add it to
my...
|
August 29th, 2008 01:56 PM
by Miree
|
2 |
122 |
|
|
|
|
3 |
105 |
|
|
Formula constants? by
Glenn L.[_2_]
I want to use the following formula in cell B3:
=(A3*(C29+3))-B29
However, I want to drag this formula down column B, but keep "(C29+3))-B29"
constant. I...
|
|
2 |
66 |
|
|
|
|
0 |
97 |
|
|
Match and Index for Tables by
LiAD
Can anyone tell me how to get the match and index functions to work for an
8x8 table?
So for example I would like the function to take a given text string ec...
|
|
4 |
80 |
|
|
|
|
7 |
99 |
|
|
Group a set of 'time' by
lelynx
Hi,
I have a set of data in time format as such...
0:10:38
0:10:36
0:08:57
0:31:44
0:30:39
0:29:19
|
August 29th, 2008 10:45 AM
by EddS
|
3 |
79 |
|
|
|
August 29th, 2008 09:34 AM
by Mifty
|
9 |
98 |
|
|
|
August 29th, 2008 07:06 AM
by Max
|
1 |
123 |
|
|
|
August 29th, 2008 06:42 AM
by Max
|
5 |
144 |
|
|
Make a cell display the contents of a shape by
JasperBluto
I finally found out (thanks to all you helpful folks!) how to get a drawing
object or text box to display the contents of a cell.
Now, I need the opposite......
|
|
0 |
82 |
|
|
|
August 29th, 2008 05:05 AM
by Ray
|
3 |
102 |