Identifying when all values in a range are the same.
 

I have a row of user inputted responses (e.g., F20:K20). The possible
responses are €œNone€�, €œLow€�, €œMedium€�, and €œHigh€�. These result in a number
value = 0, 1, 3, or 5, respectively in cells L20:Q20. Id like a routine
that will create an €œX€� in a table on a separate worksheet when all of the
number values for a particular row are the same (e.g., all 0s in L20:Q20).
The problem is that it is not known beforehand how many of the cells F thru K
(and hence, cells L thru Q) will have responses. If a cell in the range F
thru K is left blank, a €œFALSE€� is returned in the corresponding cell in the
range L thru Q. However, I dont want the €œFALSE€� cells to be included in
the determination of whether all of the number values for a particular row
are the same. A second, issue is that when the number values for a
particular row are the same, it is not known beforehand what the number value
will be, other than it will be either 0, 1, 3, or 5.

Anyones help is greatly appreciated. Thank you.

Identifying when all values in a range are the same.
 

=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
--
Gary''s Student - gsnu200820

Identifying when all values in a range are the same.
 

GS
This seems to be returning "all the same" for everything, even when the
values in L:Q are not all the same.
Help. Thanks.

"Gary''s Student" wrote:

=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
--
Gary''s Student - gsnu200820

Identifying when all values in a range are the same.
 

Are L20:Q20 formatted as text? They need to be actual numbers. Also, since
they are coming from a formula, make sure the formula returns a number, e.g.
=IF(F20="med",3,false)
and NOT
=if(F20="med","3",false)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MichaelZ" wrote:

GS
This seems to be returning "all the same" for everything, even when the
values in L:Q are not all the same.
Help. Thanks.

"Gary''s Student" wrote:

=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
--
Gary''s Student - gsnu200820

Identifying when all values in a range are the same.
 

GS,
I apologize, I was pointing to the wrong spreadsheet. Your formula appears
to be working fine.
Thanks ever so much.
MZ

"MichaelZ" wrote:

GS
This seems to be returning "all the same" for everything, even when the
values in L:Q are not all the same.
Help. Thanks.

"Gary''s Student" wrote:

=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
--
Gary''s Student - gsnu200820

Identifying when all values in a range are the same.
 

How and where did you copy the formula?

You shoud enter the formula given by Gary's Student in a cell in Row 20
=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
then copy it down..

I tested on sample data and it works as it should.


"MichaelZ" wrote:

GS
This seems to be returning "all the same" for everything, even when the
values in L:Q are not all the same.
Help. Thanks.

"Gary''s Student" wrote:

=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
--
Gary''s Student - gsnu200820

Identifying when all values in a range are the same.
 

Apologies not needed, glad I could help
--
Gary''s Student - gsnu200820


"MichaelZ" wrote:

GS,
I apologize, I was pointing to the wrong spreadsheet. Your formula appears
to be working fine.
Thanks ever so much.
MZ

"MichaelZ" wrote:

GS
This seems to be returning "all the same" for everything, even when the
values in L:Q are not all the same.
Help. Thanks.

"Gary''s Student" wrote:

=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
--
Gary''s Student - gsnu200820

Identifying when all values in a range are the same.
 

Gary's Student, Luke M, and Sheeloo,

Gary's Student's formula is working just great. I was pointing to the wrong
sheet. Problem solved. Thanks for everyone's quick and accurate advice.
MZ

"Sheeloo" wrote:

How and where did you copy the formula?

You shoud enter the formula given by Gary's Student in a cell in Row 20
=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
then copy it down..

I tested on sample data and it works as it should.


"MichaelZ" wrote:

GS
This seems to be returning "all the same" for everything, even when the
values in L:Q are not all the same.
Help. Thanks.

"Gary''s Student" wrote:

=IF(MIN(L20:Q20)=MAX(L20:Q20),"all the same","not all the same")
--
Gary''s Student - gsnu200820