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

Aldin Linton · 06-07-2006, 03:15 PM

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.

**mrice** · 06-07-2006, 04:33 PM

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)

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

LinkBack

Thread Tools

Rate This Thread

Display

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

Response

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions