formula in I2= =A2&B2&G2
formula in J2= =COUNTIF($I$2:$I$25,I2)
formula in K2= =I2=I3
formula in L2= =IF(OR(K2,J2>=3,K1),"Copy","Do not copy")
Filter the data in column L and copy to desired sheet.
Santosh
- 12.4k
- 4
- 43
- 74