Thread: Return as many Y as the number of occurrence of values in another column
View Single Post
 
Old 11-27-2020, 05:19 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Into C2 enter formula like
Code:
=IF(AND(OR($A2=$A1,$A2=$A3),OR(COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,1)>0,COUNTIFS($A$2:$A$10,$A2,$B$2:$B$10,2)>0)),"Y","")
, and copy down.
Reply With Quote