|
|
|
Sum the number of days between dates by Month
Sun, 5 Oct 2008 05:47:01 -0700
Iâ??m trying to summarise the number of NETWORKDAYS spent on projects by month.
The data I have is as follows: (dates are in UK format)
A B C
1 Project Name Start Finish
2 Project One 22/02/2008 13/03/2008
3 Project Two 22/02/2008 06/03/2008
4 Project Three 25/02/2008 11/03 ...
|
Permutation result
Sun, 5 Oct 2008 05:23:00 -0700
Hi,
I was tryinig to work on Permutation Combination keys in excel.
I wanted to know how many combinations of 4 letters can be generated and
what are they.
Problem Example:
1112
result (in different cells):
1112
1121
1211
2111
any help? ...
|
Sumif function
Sun, 5 Oct 2008 00:35:00 -0700
I have classifcation types as CC1,CC2,CC3 etc.,.under each classification
there may be different cable types(say 12C,7C,3C etc) and respective cable
lengths.sometimes under one classification there may be n number of cable
types.The above data is one sheet say Cable Data.Now I want in another
sheet(say summa ...
|
matching records and linking to other sheets if true
Sat, 4 Oct 2008 23:33:00 -0700
let me explain it to u in detail....suppose i m making a record of an college
which includes name,permanent addess,hostel name,phone no etc....now i also
want that i get hostel specific records also(for that i have made diiff
sheets namely hostel 1,hostel 2 etc)...i want that when i enter hostel 1 in
the hos ...
|
Multiple array formula using 'does not equal
Sat, 4 Oct 2008 23:26:00 -0700
I need to write a sumproduct formula whre one of the arrays needs a 'does not
equal' item. Previously with 'equals' items the formula read:
=sumproduct(--(compiled!$A$2:$A$50="abc"),--(Compiled!$G$2:$G$50="L"),--(Compiled!$F$2:$F$50>0))
This gave me the number of entries that were abc with an L entry and a v ...
|
how do I use the inverse sine (sin -1) function in Excel 2007?
Sat, 4 Oct 2008 22:21:01 -0700
Hi
Please let me know how to use the inverse sin (sin -1 ) function in
Excel 2007?
Thanks
Priyanthi. ...
|
Moving completed row to another worksheet
Sat, 4 Oct 2008 22:11:00 -0700
Hi all,
Is there a formula to automatically move (not copy) a row of completed data
to a different sheet in the same workbook. I want to move all data in a row
as long as there is a specific value of Y in Column F.
For example, Sheet 1 (Outstanding) my columns are (A-H):-
Case ID, Last Name, First Name, ...
|
|
|
SUMIF Two Conditions
Sat, 4 Oct 2008 17:50:47 -0700 (PDT)
Hi All,
This doesn't work:
=IF($B$5:$B$59<39721,SUMIF($D$5:$D$59,C65,$F$5:$F$59)) - entered as
Ctrl-Shft-Enter
I'm trying to get a total amount in column F if the date in column B
is less than 39721 (30-Sep-08), and column D matches C65.
Then I need the same thing, but with the date within a range, e.g ...
|
SUMIF Two Conditions
Sat, 4 Oct 2008 17:35:14 -0700 (PDT)
Hi All,
This doesn't work:
{=IF($B$5:$B$59<39721,SUMIF($D$5:$D$59,C65,$F$5:$F$59))}
I'm trying to get a total amount in column F if the date in column B
is less than 39721 (30-Sep-08), and column D matches C65.
What am I doing wrong?
Help would be appreciated,
Michele
...
|
How to test for imported Access table null cell?
Sat, 4 Oct 2008 15:06:28 -0700
Greetings!
Am reading data from Excel into Access to do some manipulations, then
bringing it back to Excel. A new field in the Access return data sometimes
has a null value. I see I can use the Access NZ function in the query to
force it to a "" value rather than null.
However, as is, I have a cell value ...
|
|
|
