|
|
|
July 12th, 2008 05:10 AM
by Max
|
7 |
126 |
|
|
|
|
6 |
112 |
|
|
|
|
0 |
76 |
|
|
|
|
1 |
96 |
|
|
|
|
2 |
116 |
|
|
Printing by
Dave
How can I get a macro command to print a worksheet please.?
Thanks
Dave
|
|
2 |
84 |
|
|
Data Validation and combination by
UTResearchAnalyst
I am making an energy efficiency calculator for a fleet of vehicles. For
each year, make and model, I have specific information as to MPG, CO2, and
Air...
|
|
3 |
81 |
|
|
Filtering by
[email protected]
Hello,
I am learning Excel and have been given a project on generating reports via
filtering from the spreadsheet. What is the best logical way to approach...
|
|
1 |
114 |
|
|
Average of Day and Time by
Jarod
Ok, this is a little weird, but here's the situation:
Column A has the Day of the Week: Monday, Tuesday, etc.
Column B has the numeric Date: 6/10/2008,...
|
|
3 |
78 |
|
|
sumif or if or something else???? by
durrienz
Hi
I have a source table and a spreadsheet with 2 columns with pick lists.
Table1:
Type Size1 Size2 (and so on)
type1 $10.00 $10.50
type2 ...
|
|
2 |
61 |
|
|
multiple IF formulas by
JayDee
In A1, I have a date linked from another file worksheet. I used the If (is
blank) formula so no data appears unless there is a date to link from the
other...
|
|
8 |
59 |
|
|
FONT COLOUR CHANGE by
natasha90
CAN ANYONE HELP ME!!!!
I need to change the colour of the font when a value is greater or less than
for example;
the value there should be is 5,
if the...
|
|
3 |
84 |
|
|
|
|
0 |
98 |
|
|
CONCATENATE within SUMPRODUCT by
Icarus
I have a formula in Excel 2003:
=SUMPRODUCT((E10:E1740=A1858)*(F10:F1740=B1858))
Which returns the number of rows in my worksheet range where the value
in...
( 1 2)
|
July 11th, 2008 08:23 PM
by PCLIVE
|
14 |
126 |
|
|
|
|
3 |
124 |
|
|
Table help by
K
I have data represented in the following manner
Status Date Proj # Team A Team B
TeamC
O ...
|
July 11th, 2008 07:53 PM
by K
|
0 |
57 |
|
|
|
July 11th, 2008 07:28 PM
by Pete_UK
|
3 |
76 |
|
|
|
July 11th, 2008 07:25 PM
by JBoyer
|
3 |
71 |
|
|
Quday001-Conditional Formatting by
Udayan
I have a column containing dates (A1:A100) in date format.
Colour of all the cells in that column (A1:A100) is yellow and I want to the
blank cells as it...
|
July 11th, 2008 07:01 PM
by Pete_UK
|
1 |
57 |
|
|
match or vlookup function formula help by
Belinda7237
I have a spreadsheet that has invoice numbers in column F which i want to
use to link my data into another worksheet.
0001173631
and in another worksheet I...
|
July 11th, 2008 06:43 PM
by Pete_UK
|
4 |
58 |