[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A1
[/TD]
[TD]A2
[/TD]
[TD]A3
[/TD]
[TD]A4
[/TD]
[/TR]
[TR]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[/TR]
</tbody>[/TABLE]
Hi Mrexcel Forum,
I am trying to work out a formula that looks in a range to see if all cells in that range are the same and if they are then I would like the formula to return the value that is the in the range.
Example:
Please see table above I would like the formula in A4 and the range to be A1 to A3. (for some reason I could not get the table at the bottom of my post!!)
Thank you in advance
Jamidd
<tbody>[TR]
[TD]A1
[/TD]
[TD]A2
[/TD]
[TD]A3
[/TD]
[TD]A4
[/TD]
[/TR]
[TR]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[TD]EL1
[/TD]
[/TR]
</tbody>[/TABLE]
Hi Mrexcel Forum,
I am trying to work out a formula that looks in a range to see if all cells in that range are the same and if they are then I would like the formula to return the value that is the in the range.
Example:
Please see table above I would like the formula in A4 and the range to be A1 to A3. (for some reason I could not get the table at the bottom of my post!!)
Thank you in advance
Jamidd