Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas
Is there a formula to copy data from ex. column D, based on the info in Col C?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |