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.
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.
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks