Trying to get a match on Four of Five cells, which formula is use

A

Aldin Linton

I need a formula to expedite my work. I need to find a way to get an output
from 5 cells in which at leats 4 match. The matching four are not in a set.
 
M

mrice

Try this

=IF(OR(AND(A1=A2,A2=A3,A3=A4),AND(A2=A3,A3=A4,A4=A5),AND(A1=A2,A2=A4,A4=A5),AND(A1=A3,A3=A4,A4=A5),AND(A1=A2,A2=A3,A3=A5)),TRUE,FALSE
 
Top