|
|
|
|
3 |
376 |
|
|
Conditional Formatting - Test Practice by
downinfl
I want to design a test for my students, who need to memorize -- verbatim --
a list of 37 characteristics. I would like to use an Excel 2007 spreadsheet
to...
|
|
0 |
280 |
|
|
Sumproduct Problem (AB) by
albertmb
Hi everyone, can you please sort out this problem for me?
SUMPRODUCT(('Client Opening Stock'!B2:B138=$A$1)*('Client Opening
Stock'!C2:AH138=A7),'Client...
|
|
4 |
242 |
|
|
|
|
3 |
289 |
|
|
Formating Dates by
LovingLife28
I need to update a list of dates to show all days as 01. For example, where
date shows 03/28/2009, I need it to read 03/01/2009. I appreciate any...
|
|
4 |
160 |
|
|
|
|
0 |
163 |
|
|
Auto sorting to match by
Very Basic User
Hello All,
I have a spreadsheet that automatically sorts catagories by largest loss or
lowest # in another column. My original data is not sorted in the same...
|
|
1 |
160 |
|
|
TABLE ROW SORT ERROR? by
RAY
Hi all - I have a 22+ column by 867 row table. Three columns host formulas
on each row that refer to values on the same row. Everything is fine until I...
|
|
1 |
197 |
|
|
|
|
1 |
150 |
|
|
|
|
1 |
197 |
|
|
|
|
3 |
184 |
|
|
|
May 6th, 2010 07:21 PM
by jlr
|
1 |
163 |
|
|
sub total value by
creating a reference list
I have 4000 lines of data and I have used the sub total function to obtain
the value that I need. How can I sort the data by the sub total value?
|
|
1 |
157 |
|
|
Excel subtotals by
Michele
I have a list that is approx 2000 rows by 8 columns (A:H) which needs to be
subtotaled in Column H on each change in column G. Once the list is
subtotalled...
|
|
1 |
130 |
|
|
|
|
1 |
175 |
|
|
Adding up hours and minutes by
Dave
Hi,
I need to add up a list of hour and minutes, the only problem being is that
Excel treats them as TIME not hours and minutes.
For example, if I sum 7:24,...
( 1 2)
|
|
19 |
546 |
|
|
|
|
2 |
244 |
|
|
|
May 6th, 2010 05:43 PM
by S
|
2 |
206 |
|
|
Time in Seconds Only by
Chad Cameron
Hi All,
I have to enter a bunch of times that are less than 1 minute. Is there an
easier way to enter times than 0:0:15?
I would like to just enter 15 and...
|
|
2 |
143 |
|
|
|
May 6th, 2010 05:22 PM
by Paul C
|
3 |
174 |