Hi,

You can use Data-Filter-Advanced Filter for this. In the reference
section, you just have to give the referenc of col C. After applying the
advanced filter, the data is filterd out and now you can copy them.

Thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"Formula1" wrote:

Is there a formula to copy data from ex. column D, based on the info in Col C?