F
Formula1
Is there a formula to copy data from ex. column D, based on the info in Col C?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DILipandey
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.)
[email protected]
[email protected]
New Delhi, India
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.)
[email protected]
[email protected]
New Delhi, India
M
MFS
You can try this, if D1 bigger then 1,000 copy C1, if not put 0
=IF(D2>1000;C2;0)
=IF(D2>1000;C2;0)
M
MFS
sorry
You can try this, if C1 bigger then 1,000 copy D1, if not put 0
You can try this, if C1 bigger then 1,000 copy D1, if not put 0
M
MFS
Sorry No2
You can try this, if C1 bigger than 1,000 copy D1, if not put 0
=IF(C2>1000;D2;0)
You can try this, if C1 bigger than 1,000 copy D1, if not put 0
=IF(C2>1000;D2;0)