|
|
|
April 8th, 2010 05:15 PM
by ewillig
|
5 |
96 |
|
|
Multiple IF statement by
J.Scargill[_2_]
Hi guys,
A little help required please.
I have a worksheet that looks like this;
J L
10 Y 1
11 Y 2
12 N ...
|
April 8th, 2010 04:28 PM
by Paul C
|
1 |
113 |
|
|
Pivot Table Totals by
Mick Henn[_2_]
Is there any way that i can add an extra column to a pivot table that I can
add a function into?
We have 2 internal quality checks for our product. I have...
|
|
6 |
152 |
|
|
Return of value when copying a formula by
Stinky
I've created a v simple in order to get data from one
spreadsheet to another. However, when I copy the function across the
spreadsheet, it is returning the...
|
|
4 |
97 |
|
|
Printing problems with hidden rows by
Banker
I have a sheet with 5 templates divided by page breaks. When only 2
templates are needed, I hide the rows that I do not wish to be printed so it
will only...
|
April 8th, 2010 03:52 PM
by Banker
|
1 |
160 |
|
|
Hiding rows and printing by
Banker
I have the print area set to A1..H340 with 4 manual page breaks inserted. I
have hidden rows 200 thru 340 and when I print, I still get 5 pages - two
pages...
|
April 8th, 2010 03:51 PM
by Banker
|
1 |
136 |
|
|
trouble with closed workbook by
Bob L[_2_]
I have a few spreadsheets that are linked to other workbooks. Everyone says
that you cannot get data from a closed workbook. Here is what I have. I
have...
|
|
2 |
122 |
|
|
Function Lookup by
Heather
=IF(Routing_Count_04072010!A:A = "COB",Routing_Count_04072010!B:B,0)
I can use the above as long as the fields do not change and it works
perfectly. When...
|
|
3 |
146 |
|
|
|
|
9 |
132 |
|
|
|
|
2 |
206 |
|
|
Repeating rows not wanted by
Opal[_3_]
I am running Excel 2003 and not sure why this
is happening. I have a 2 page report and there
is a header plus I have flagged two rows to
repeat at top (12 &...
( 1 2)
|
|
11 |
351 |
|
|
|
|
2 |
175 |
|
|
to Sohail by
Stefi
If you don't write anything in the message body, your post can't be replied to!
http://tinyurl.com/8n4fz
by Bob Phillips
You could download Laurent...
|
April 8th, 2010 12:33 PM
by Stefi
|
0 |
173 |
|
|
|
April 8th, 2010 11:30 AM
by aganoe
|
4 |
167 |
|
|
|
April 8th, 2010 09:02 AM
by Andrew
|
0 |
143 |
|
|
Depreciation Spreadsheet by
Michele
Hi
I'm having a little trouble calculating some formulas in my depreciation
budget worksheet.
What I need to be able to calculate is when an asset is only...
|
|
3 |
154 |
|
|
Data moving 3 by
climate
Hi
I need to a code, when run it on any sheet, copy of column X paste to a file
(R.xls) in sheet1 and locate on column H respectively. in otherwords, first...
|
April 8th, 2010 07:28 AM
by climate
|
1 |
151 |
|
|
|
|
1 |
125 |
|
|
excel crashes when changing web query by
Graeme
Hi,
In excel 2003, i have a file that pulls in data via Data / Import External
Data / New Web Query. I've been using the file for about 3 years, and now...
|
April 8th, 2010 04:52 AM
by Graeme
|
0 |
134 |
|
|
Formula to Return age by
JLatham
see
http://www.cpearson.com/excel/datetimews.htm
scroll down just a few lines and he has a formula for determining age in
years, months and days.
"Mark"...
|
|
1 |
166 |