View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kashyap Kashyap is offline
external usenet poster
 
Posts: 131
Default Copy corresponding cell if value is 0

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