formula to finding matching/non matching values based on values in two columns

Question

Hi&nbsp;&nbsp;trying to find a formula that could achieve the following as column "required output"Trying to identify tasks that have the same ID but different times recorded&nbsp;&nbsp;&nbsp;Time&nbsp; &nbsp; &nbsp; &nbsp;TaskID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; required output00:21&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; no00:50&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;yes01:30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;yes01:40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; no01:40&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; no&nbsp;thanks

harun24hr · Accepted Answer

cheezy&nbsp;COUNTIFS() may work.=IF(COUNTIFS($B$2:$B$6,B2)=1,"No",IF(COUNTIFS($A$2:$A$6,A2,$B$2:$B$6,B2)=1,"Yes","No"))&nbsp;&nbsp;

Forum Discussion

formula to finding matching/non matching values based on values in two columns

2 Replies

Resources