Re: MATCH Function giving odd results
Wed, 26 May 2010 05:16:20 -0700 (PDT)
Steve, you're a star.
Thanks for all your help, guys. Much appreciated.
On 26 May, 13:11, "Steve Dunn" <st...@sky.com> wrote:
> The default return type for MATCH is 1, which finds the *largest* value that
> is less than or equal to lookup value and of course the list must be sorted
> for this to work corre ...
|
MATCH Function giving odd results
Wed, 26 May 2010 04:29:24 -0700 (PDT)
Hi experts.
I wonder if you can help. I'm running a MATCH function on some data
like this:-
a
b
c
d
d
e
When I try the function =MATCH("d",A1:A6) I get 5 as my result. Why?
Should it not be 4 as the first time "d" appears in the range is
fourth? I'm confused by it.
Hope somebody can explain.
...
|
Changing Part of a Formula En Mass
Wed, 26 May 2010 09:31:01 +0100
Good morning,
I need to edit part of a formula in many cells - but they don't all follow
each other - so I cannot use the fill option.
Is there anyway that I can edit text within the spreadsheet? Almost like a
flat file where I do a find and replace?
Thanks
...
|
Help requested with text parsing
Wed, 26 May 2010 08:02:31 +0100
I have example data as follows (the current top 3 singles on iTunes, as
it happens) :
1. Dirtee Disco (Radio Edit) - Dizzee Rascal
2. Nothin' On You - B.o.B
3. Solo - Iyaz
What I want to do is split it across three columns, dividing it after
the chart position, and the song title.
I know I could do it ...
|
Resource Planing Excel Sheet
Wed, 26 May 2010 05:05:39 GMT
Hi,
Is there a good (free) excel sheet that can help resource planning? With
the tool, i want to list resource (people) usage in varity of projects,
from now to the remained times of the year, in weekly and monthly basis.
Thanks.
--
Life is the only flaw in an otherwise perfect nonexistence
-- Schop ...
|
compare betwen two values
Tue, 25 May 2010 20:42:29 -0700 (PDT)
dear all,
in below table, when I input a number in the "input" cell, the result
will be returned the value of column C. I used vlookup function. But
this function cannot compare the number is between column A & B. In
below example, I expect it will return "Not Found". I tried to use IF,
but it was too long.
Pl ...
|
replacing zeros by blank cells
Tue, 25 May 2010 14:47:01 -0700
Hi,
Charts read cells with 0 as value, but a blank cell as a missing value so
that it is not presented on the chart. What is the trick to replace the zeros
in a large table by blank cells?
Thanks for your help,
--
milet ...
|
|
|
How to vary shading of groups of rows, based on change in value in a
particular column
Tue, 25 May 2010 11:45:34 -0700 (PDT)
I am attempting to vary shading of groups of rows, based on change in
value in a particular column.
For example.
Column A Column B
Bob 5
Bob 6
Jeff 3
Jeff 8
Jeff 2
Eric 3
Eric ...
|
Work hour tracing program
Tue, 25 May 2010 18:01:49 GMT
Hi,
Could anyone recommend a work hour tracing excel sheet for me? I like to
find a good and free one. I should be able to define tasks and log tasks
in hourly wise.
Thanks.
--
Life is the only flaw in an otherwise perfect nonexistence
-- Schopenhauer
narke ...
|
Cell Format
Tue, 25 May 2010 06:55:18 -0700 (PDT)
I want to enter <shift>: in a cell (this would be Shift Key and the
colon character to enter a date).
And then automatically format this cell so that the date is on one
line, and the value "Critical Date" on the second line.
So the cell value would look like this:
05/25/2010
Critical Date
Can someone ...
|