Cell than number of other cells..
 

Hi, was wondering if can do something for 1 cell greater than a number of
other cells, together instead of separately, such as:

=A1{C1,F1,H1}

Cell than number of other cells..
 

nastech wrote:
Hi, was wondering if can do something for 1 cell greater than a
number of other cells, together instead of separately, such as:

=A1{C1,F1,H1}

Well you can use sumproduct for a range thus:

=SUMPRODUCT((A1C1:H1)*1*(C1:H1<""))0

Cell than number of other cells..
 

Neat trick:

If A1 is greater than a set of numbers it must be greater than the max of
the set. use:


=(A1MAX(C1,F1,H1))
--
Gary's Student


"nastech" wrote:

Hi, was wondering if can do something for 1 cell greater than a number of
other cells, together instead of separately, such as:

=A1{C1,F1,H1}

Cell than number of other cells..
 

Gary''s Student wrote:
Neat trick:

If A1 is greater than a set of numbers it must be greater than the
max of the set. use:


=(A1MAX(C1,F1,H1))

Why do I so often miss the simple approach and try complicating matters.
Nice one!

Cell than number of other cells..
 

thanks, thats great..

"Gary''s Student" wrote:

Neat trick:

If A1 is greater than a set of numbers it must be greater than the max of
the set. use:


=(A1MAX(C1,F1,H1))
--
Gary's Student


"nastech" wrote:

Hi, was wondering if can do something for 1 cell greater than a number of
other cells, together instead of separately, such as:

=A1{C1,F1,H1}

Cell than number of other cells..
 

Hi, was wondering if you knew a short cut for this one too: have %change
equation, that adds a cummulative of change for each day, but do not know how
to abbreviate. (must keep original amounts in each column to show direction
up/dn)

(adding separate amounts for each day, for each range selected, such as:
2=(day1+day2),3=(day1+day2+day3)... (thanks)

long verson:
=IF(OR(BS9="",COUNTA(BT9:BX9)=0,MIN(BT9:BX9)=MAX(B T9:BX9)),"",
IF(OR($BH$2={"",".",2}),(BS9/BT9%-100)+(BT9/BU9%-100),IF($BH$2=3,(BS9/BT9%-100)+(BT9/BU9%-100)+(BU9/BV9%-100),
IF($BH$2=4,(BS9/BT9%-100)+(BT9/BU9%-100)+(BU9/BV9%-100)+(BV9/BW9%-100),
IF($BH$2=5,(BS9/BT9%-100)+(BT9/BU9%-100)+(BU9/BV9%-100)+(BV9/BW9%-100)+(BW9/BX9%-100))))))

"Gary''s Student" wrote:

Neat trick:

If A1 is greater than a set of numbers it must be greater than the max of
the set. use:


=(A1MAX(C1,F1,H1))
--
Gary's Student


"nastech" wrote:

Hi, was wondering if can do something for 1 cell greater than a number of
other cells, together instead of separately, such as:

=A1{C1,F1,H1}