Formulas

  • Thread starter Thread starter Formula1
  • Start date Start date
F

Formula1

Is there a formula to copy data from ex. column D, based on the info in Col C?
 
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.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
You can try this, if D1 bigger then 1,000 copy C1, if not put 0
=IF(D2>1000;C2;0)
 
sorry

You can try this, if C1 bigger then 1,000 copy D1, if not put 0
 
Sorry No2
You can try this, if C1 bigger than 1,000 copy D1, if not put 0
=IF(C2>1000;D2;0)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

With F1 value, look at A, if match or partial match return B 5
Selecting and applying the correct forumla 2
Increment a number based on four adjoing cells 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Lookup Formula 4
validation drop down list question 1
match and extract 4
Formula For Counting Records 5

Back
Top