match and return

[rhollo]

I have a row of cells A1:A6 and each cell has a formula to return
given value and, if more than one cell returns a value, each cell wil
have the same values. Example:

if A1=100 then if A2:A6 return a value it will be 100 also.
if A2=100 then if A1,A3:A6 return a value it will be 100 also.

What I'm looking to do is if a value returns in any cell A1:A6, retur
that value to B1 and if that same value returns in any or all othe
cells, return only the first value to B1. Example:

if A1=100 then B1=100
if A2=100 and A5=100 then B1=100
if each cell A1:A6=100 then B1=100

Can anyone help? TI

 

[Guest]

Hi rhollo
Try using the MAX function

=MAX(A1:A6

Since all of the values will always be the same, this will just return whatever that value happens to be

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- rhollo > wrote: ----

I have a row of cells A1:A6 and each cell has a formula to return
given value and, if more than one cell returns a value, each cell wil
have the same values. Example

if A1=100 then if A2:A6 return a value it will be 100 also.
if A2=100 then if A1,A3:A6 return a value it will be 100 also

What I'm looking to do is if a value returns in any cell A1:A6, retur
that value to B1 and if that same value returns in any or all othe
cells, return only the first value to B1. Example

if A1=100 then B1=10
if A2=100 and A5=100 then B1=10
if each cell A1:A6=100 then B1=10

Can anyone help? TI

 

[Guest]

Hi

If A1:A6 has no values then Max Function returns a zero, so would the following be advisable

IF(ISERROR(SUM(A1:A6)/COUNTA(A1:A6)),"",SUM(A1:A6)/COUNTA(A1:A6)

Regards
Har
Indi

----- Mark Graesser wrote: ----

Hi rhollo
Try using the MAX function

=MAX(A1:A6

Since all of the values will always be the same, this will just return whatever that value happens to be

Good Luck
Mark Graesse
(e-mail address removed)
Boston M

----- rhollo > wrote: ----

I have a row of cells A1:A6 and each cell has a formula to return
given value and, if more than one cell returns a value, each cell wil
have the same values. Example

if A1=100 then if A2:A6 return a value it will be 100 also.
if A2=100 then if A1,A3:A6 return a value it will be 100 also

What I'm looking to do is if a value returns in any cell A1:A6, retur
that value to B1 and if that same value returns in any or all othe
cells, return only the first value to B1. Example

if A1=100 then B1=10
if A2=100 and A5=100 then B1=10
if each cell A1:A6=100 then B1=10

Can anyone help? TI

 

[Peo Sjoblom]

No it wouldn't be advisable, too much to write, use

=AVERAGE(A1:A6)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

Hi,

If A1:A6 has no values then Max Function returns a zero, so would the following be advisable.

IF(ISERROR(SUM(A1:A6)/COUNTA(A1:A6)),"",SUM(A1:A6)/COUNTA(A1:A6))

Regards,
Hari
India

----- Mark Graesser wrote: -----

Hi rhollo,
Try using the MAX function:

=MAX(A1:A6)

Since all of the values will always be the same, this will just

return whatever that value happens to be.