|
|
Copying and updating formulas by
dimitry
I have a workbook with mutiple sheets, each corresponding to a date. I
use a formula which is the
actual stock, based on the remainig of the previous. I...
|
August 2nd, 2008 07:42 PM
by dimitry
|
0 |
74 |
|
|
|
August 2nd, 2008 07:17 PM
by Pierre
|
0 |
111 |
|
|
Need help with formula by
Gerd
Hi. I would like help with the following problem. A1 contains the total job
costs and is constantly being updated. At the end of the first invoice
period...
|
August 2nd, 2008 07:06 PM
by Gerd
|
2 |
167 |
|
|
Count instances of text in date entries by
MilusC
I'm using Excel 2007. I have a column of dates in this format - 04-Aug-08,
15-Jul-08, etc. I would like to count the number of times a certain month
shows up...
( 1 2)
|
|
11 |
207 |
|
|
tab name = cell value by
jatman
is it possible to have a cell value equal the same as a sheet (tab) name?
just something simple as =sheet1 or something
thank you,
|
|
7 |
171 |
|
|
|
|
1 |
172 |
|
|
index match by
Anthon
A B C D
ROW 5 1 65 6 56
ROW 6 2 100 7 41
ROW 7 3 34 8 32
ROW 8 4 6 ...
|
|
4 |
96 |
|
|
Need Formula by
vmohan1978
Summary
8mm 10mm 12mm 16mm 20mm 25mm 32mm ...
|
|
2 |
89 |
|
|
Conditional Formatting Q by
Sean
What formula could I use within CF to express the following
If A1 in Sheet1 is less than or equal to 80% of the value of A1 in
Sheet2, then change text colour...
|
|
1 |
81 |
|
|
|
|
5 |
145 |
|
|
Figure future date by
J
Is it possible to have cell A1 with todays date and make B1 add 1 week to
that date and display it?
|
|
7 |
212 |
|
|
|
|
7 |
99 |
|
|
is this possible ? by
Ms_M_o_n_i_c_a
I want to create a drop down list with only the item & function. Then
depending on what item/function is picked, i need the dept and class and
subclass to...
|
|
3 |
86 |
|
|
|
August 2nd, 2008 02:23 AM
by smartin
|
1 |
123 |
|
|
% of Subtotal In Pivot Table by
Milodie66
Is it possible to utilize options or any other field to build a % of a value
against the subtotal of the group. Example: Sales is my group, I have
multiple...
|
August 2nd, 2008 12:56 AM
by smartin
|
1 |
107 |
|
|
Notes and Coinage for Wages by
Owl
If, for example, one labourer’s wages for the week are R1843, is there a
simpler way to work out the notes and coins to be got from the bank, than the...
|
|
3 |
92 |
|
|
Need Function for Year-to-Date spent total by
mokshadavid
I'm doing a Budget Worksheet for the Fiscal Year 08-09. I am looking for a
function that takes the previous month worksheet's "YTD spent" total, adds it
to...
|
|
3 |
139 |
|
|
Excel Spreadsheet by
july
I have created a form on worksheet 1....I want to enter the data on worksheet
2 to automatically populate on the form in worksheet 1... but keep a running...
|
August 2nd, 2008 12:39 AM
by JLatham
|
3 |
90 |
|
|
Automatically Populating a Worksheet by
TS
I have worksheet that has certain information about our manufacturing
operation. I have another worksheet where I would like to extract certain
data from the...
|
|
2 |
119 |
|
|
Find & Replace by
chiefwidmer
Is it possible to replace the contents of an entire row if that row has a
cell which was found with the F & R function?
When using the F&R function it found...
|
|
1 |
70 |