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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Trying to get a match on Four of Five cells, which formula is use (https://www.excelbanter.com/excel-discussion-misc-queries/92721-trying-get-match-four-five-cells-formula-use.html)

Aldin Linton

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

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

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

Try this

=IF(OR(AND(A1=A2,A2=A3,A3=A4),AND(A2=A3,A3=A4,A4=A 5),AND(A1=A2,A2=A4,A4=A5),AND(A1=A3,A3=A4,A4=A5),A ND(A1=A2,A2=A3,A3=A5)),TRUE,FALSE)

--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=549649

All times are GMT +1. The time now is 03:12 PM.