Strip out text from cells
Sat, 11 Oct 2008 11:52:01 -0700
Hi
Below is an example of what I have done but excel keeps reversing the
formula back to g to h instead of h to g.
=MID(G5,1,FIND(h5:g5,1)-1) this what I enter.
=MID(G5,1,FIND(G5:H5,1)-1) this what i get.
Column A Col B Col C
Result
12T ...
|
Add a name to selected cells
Sat, 11 Oct 2008 09:50:01 -0700
In a sheet I have a variable selection of cells. I want to add a name
(overviewselection) to these cells with a macro. How should I do that? ...
|
Averaging data in a list between two dates.
Sat, 11 Oct 2008 17:01:55 +0200
Hi,
I'm trying to use a table that is here :
http://www.euribor.org/html/download/eonia/eonia%201999-2002.xls
Sheet1 will do for example.
Example
31-déc-02 3.44
27-déc-02 3.03
24-déc-02 3.05
23-déc-02 3.7
20-déc-02 3.5
....
I'm trying to find the average rate (Column ...
|
Adding a leading space to a numeric column
Sat, 11 Oct 2008 07:58:05 -0700 (PDT)
Group:
How can I add a leading space to a column of numbers in excel?
Excel 2007
For example:
12345
54321
98761
I need a space peceding the numbers.
Thanks in advance.
Terry ...
|
How to copy formulas exactly as is
Sat, 11 Oct 2008 06:55:53 -0700
Is there a way to copy/move a range exactly as is without Excel
guessing what I want and adjusting the cell references?
Say D5:D100 contains "=Bn-Cn".
If I copy it to E5:E100, I get "=Cn-Dn".
Is there a way to copy that range and have the cell references
unchanged?
I tried clicking on the little Paste ...
|
Remember Lowest Value in Cell
Sat, 11 Oct 2008 04:57:30 -0700 (PDT)
Cell D3 contains a numeric value.
As data is changed in cell D3, I want cell G3 to keep track of the
lowest value that was entered in Cell D3.
How do I do this?
Thanks ...
|
# NEW CHALLENGE: HOW TO PRODUCE COMBINATIONS OF DIFFERENT RANDOM
NUMBERS AND DO NOT FULLY single repeatable in Excel 2003?
Sat, 11 Oct 2008 01:22:03 -0700 (PDT)
# NEW CHALLENGE: HOW TO PRODUCE combinations of different random
numbers
AND DO NOT FULLY single repeatable in Excel 2003?
Well I found a function that produces random numbers different
each other. The only problem is that since they need to apply
function repeatedly through a cycle of VBA macro (DO. ... LOOP ...
|
|
|
Re-set a date to the first of the month
Fri, 10 Oct 2008 16:34:46 -0700 (PDT)
Hello,
I need to re-set whatever date is entered in a cell to the first of
that month. For example if someone enters 9/11/2008, I need it to be
re-set to 9/1/2008.
Is this possible, and if so, can you please tell me how to do it??
thanks in advance! ...
|
Vlookup
Fri, 10 Oct 2008 14:22:18 -0700
Keep getting a n/a#
Trying to pull second and third column pff a different worksheet
Says my lookup value is the problem
--
Mike Fitz ...
|
Ratios
Sat, 11 Oct 2008 07:21:38 +1100
Hi,
I am looking how to show a ratio. For instance, if I have 100 apples and 20
of them are rotten then the ratio is 5:1, i.e. 5 good apples to every bad
apple. If I have 100 and 19 are bad the ratio is 5.26:1 or something like
that? I'm sure there would be a formula to get the ratio to show in a cell
aut ...
|
