Formulas
Is there a formula to copy data from ex. column D, based on the info in Col C?
|
Formulas
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? |
Formulas
You can try this, if D1 bigger then 1,000 copy C1, if not put 0
=IF(D21000;C2;0) -- MFS22 "Formula1" كتب: Is there a formula to copy data from ex. column D, based on the info in Col C? |
Formulas
sorry
You can try this, if C1 bigger then 1,000 copy D1, if not put 0 =IF(C21000;D2;0) -- MFS22 "MFS" كتب: You can try this, if D1 bigger then 1,000 copy C1, if not put 0 =IF(D21000;C2;0) -- MFS22 "Formula1" كتب: Is there a formula to copy data from ex. column D, based on the info in Col C? |
Formulas
Sorry No2
You can try this, if C1 bigger than 1,000 copy D1, if not put 0 =IF(C21000;D2;0) -- MFS22 "MFS" كتب: You can try this, if D1 bigger then 1,000 copy C1, if not put 0 =IF(D21000;C2;0) -- MFS22 "Formula1" كتب: Is there a formula to copy data from ex. column D, based on the info in Col C? |
All times are GMT +1. The time now is 06:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com