is there anyway to put together these formula for Column 2 and 3 in the work book
=AND($E4=$H4,$E4<>"")
=IF(COUNTIF($E$1:E4,E4)<3,1,0)