Spreadsheet calculations with offsets
Sat, 23 Aug 2008 09:21:46 -0700
Hello,
I am currently new to working with MS excel sr-1 and need some help on
create a spread sheet that can calculate various offset distances based on a
length of a line and the beginning and end distance.
Can someone explain to me how this is done.
Thanks
...
|
Return string between two spaces
Sat, 23 Aug 2008 17:37:18 +0200
I have a string like this in a cell: AAAA T52650 BBBB.
Need a function to return T52650.
AAAA, T52650 and BBBB can be of variable length, but there will always be a
space between the three.
Anyone???
...
|
If/Condition Applied to Pictures?
Sat, 23 Aug 2008 08:54:00 -0400
Is it possible, with Excel 2007 to select a graphic/picture based on a
condition?
...
|
Averaging only some rows
Sat, 23 Aug 2008 04:34:36 -0700 (PDT)
I have an application where I want to calculate the average of several
fields, but only in those rows where the second column is blank. For
example:
(A3)1 (A4)<blank> (A5)10 (A6)0
(B3)1 (B4)<blank> (B5)20 (B6)2
(C3)50 (C4)some text (C5)500 (C6)0
(D3) 1 (D4)<blank> (D5)15 (D6)4
should give me for a ...
|
Filters - Numbering Rows
Fri, 22 Aug 2008 17:44:01 -0700
I want to number the rows of filtered cells, 1, 2, 3...
I can't fill series, or use the formula =a2+1...
Is there any way I can do this?
Cheers ...
|
Conditional formatting - highlight an entire row
Fri, 22 Aug 2008 13:28:13 -0700 (PDT)
Is there a way to use conditional formatting so that if the contents
of a single cell changes, then the entire row in that table will
change a color.
I know it can be applied to the cell, but can it be applied to the
entire row?
Thanks. ...
|
Extend formulae
Fri, 22 Aug 2008 17:27:18 +0100
In S2 I have =IF(R2="","",R2*0.034+0.2) extended down to S9.
In T2 I have =IF(R2="","",R2-S2) extended down to T9.
In U2 I have =T2.
In U3 I have =IF(R2="","",U2+T3) extended down to U9. In other words a
running total.
When I enter an amount (£) in R10, cells S10 and T10 automatically update
but no ...
|
|
|
Printing a set of spread sheets
Fri, 22 Aug 2008 19:33:47 +0530
I have a directory with about 80 identical spread sheets.
I want a macro (or some thing like that) to do the following
I have Acrobat Professional 8
1.Select first Spread sheet
2. Select a defined range (same for all) ..say A1 to G20
3 Print the selection to some other directory
4 The file name of the genera ...
|
Read Only
Fri, 22 Aug 2008 13:14:48 +0100
Hi
A couple of times now I have placed an excel 2003 file on a site for
download (winzipped), and when the file has been downloaded and extracted
and changes having been made, the user has been unable to save changes
because it has become read only.
Why would this happen (it was not read only prior to up ...
|
synchronize two pivot table
Fri, 22 Aug 2008 18:21:04 +0800
I have two pivot table on a worksheet,I want to
synchronize the page between them both.I mean,
if user select page A in the first pivot table,auto
matically the page selected on the second pivot
table is A too.Is it possible?
Hope somebody like to pint me to the right direction.
Thank's in advance.
Rgds,
...
|
