|
|
Help needed urgently by
AndyW
Hi,
Im trying to check that one row of data satifies a criteria, then if it does
it counts an entry in another column adjescent to it.
Example: -
Column A...
|
|
4 |
908 |
|
|
CONVERT function for Excel 2003 by
Chandrahas
I was trying to format time in decimals to days:hours:mins format. While
using microsoft excel 2003 help, they said to use CONVERT funtion for the
same. But...
|
|
2 |
873 |
|
|
|
|
6 |
912 |
|
|
Password to open excel file by
Suresh Lohar
How a password is set in excel sheet. When double click an excel file, first
of all
you see protected and a window appeared, asking for password to open...
|
|
2 |
810 |
|
|
copy and past cells found by SUMPRODUCT by
Tromal
I have colum A and B. I use SUMPRODUCT to calculate the sum of values in
column B with a criteria.
What I would like to do is copy the cells from column A...
|
|
1 |
916 |
|
|
countblank with sumproduct? by
Rene
Hi,
SUMPRODUCT(--(S3:S44="A"),--(E3:M44100),--(E3:M44=200))/SUMPRODUCT(--(S3:S44="A"),--(E3:M44"")) doesn't work unless it is E3:E44
Looking to modify...
|
May 30th, 2010 02:21 AM
by Brad
|
1 |
780 |
|
|
Active Cell Border Color by
Linda Oshkosh WI
I know this can be done, I just can remember how or seem to be able to find
it under help.
I would like the border around my active cell to be a different...
|
|
2 |
1,960 |
|
|
Conditional formula by
RichM
Hello,
I want to make all the conditions occur in cell b1:
if cell a1 = 1 then cell b = 7
if cell a1 = 2 then cell b = 6
if cell a1 = 3 then cell b = 5
if...
|
May 29th, 2010 06:45 PM
by RichM
|
3 |
777 |
|
|
|
|
0 |
924 |
|
|
Pivot from multiple sheets by
Radhakant Panigrahi
hi,
i have the below data and i need to make pivot from multiple sheets.i have
tried to make by selecting multiple consolidation ranges, bbut it is not...
|
|
1 |
997 |
|
|
Header Information by
Belin
I am doing a spreadsheet for my school. I am trying to put a title up top
like where the letters A, B C D are. How do I go about doing that???
Thanks
|
|
1 |
726 |
|
|
macrio soft exel by
dheeraj sharma
sir i want to find that ,in the row of an exel sheet if i hilighted one or
more one cell then i want to count that cell how?i can found ?
|
|
2 |
747 |
|
|
|
|
2 |
779 |
|
|
averageif with 3 crieteria by
Rene
SUMPRODUCT(--(S498:S534="a"),--(G498:G534=100),--(G498:G534=200))/SUMPRODUCT(--(S498:S534="a"),--(G498:G534""))
I searched questions already answered but...
|
|
2 |
745 |
|
|
Calculating date/time intervals?? by
JJ
I have multiple sets of date/time value combinations. For each start time
(date/time) and finish time (date/time), I need a formula that calculates the...
|
|
1 |
807 |
|
|
|
|
2 |
857 |
|
|
|
|
1 |
720 |
|
|
|
|
1 |
722 |
|
|
zero value in cell by
Arthur
I have a table of engineering calculations. The same formula in each cell
operation on variables in the row and column headers. i use the MIN function
to...
|
May 28th, 2010 11:06 PM
by Arthur
|
2 |
714 |
|
|
export data between spreadsheets by
scott
Hello,
how do I setup an excel file that each time when I enter data in one file it
will export to another file in the same column of subsequent rows?...
|
|
1 |
758 |