Skip to main content

Return to Answer

Commonmark migration
Source Link
Community Bot
Community Bot
  • 1
  • 1

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.

![enter image description here][1] [1]: https://i.sstatic.net/QAf0n.gifenter image description here

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.

![enter image description here][1] [1]: https://i.sstatic.net/QAf0n.gif

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.

enter image description here

deleted 12 characters in body
Source Link
Santosh
Santosh
  • 12.4k
  • 4
  • 43
  • 74

formula in I2= =A2&B2&G2
formula in J2= =COUNTIF($I$2:$I$25,I2)
formula in K2= =OR(I2=I3,I2=I3)=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.

![enter image description here][1] [1]: https://i.sstatic.net/QAf0n.gif

formula in I2= =A2&B2&G2
formula in J2= =COUNTIF($I$2:$I$25,I2)
formula in K2= =OR(I2=I3,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.

![enter image description here][1] [1]: https://i.sstatic.net/QAf0n.gif

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.

![enter image description here][1] [1]: https://i.sstatic.net/QAf0n.gif

Source Link
Santosh
Santosh
  • 12.4k
  • 4
  • 43
  • 74

formula in I2= =A2&B2&G2
formula in J2= =COUNTIF($I$2:$I$25,I2)
formula in K2= =OR(I2=I3,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.

![enter image description here][1] [1]: https://i.sstatic.net/QAf0n.gif