Copy corresponding cell if value is 0
Hi,
You could apply an AutoFilter and filter on not equal to 0, then copy the
results to a new location
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Kashyap" wrote:
Hi,
How can I copy corresponding cell if value in Col E 0..? Something like
below.
Col D |Col E
ABC |12
MNO |2
HTR |0
UTV |0
HNC |5
XYZ |6
QTR |2
GTR |0
MTR |8
Result:
Col D |Col E
ABC |12
MNO |2
HNC |5
XYZ |6
QTR |2
MTR |8
|