Analysis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Having a senior moment.

I want to place values in columns.

EG
A2=25 B2=sheep C2=A2 all other columns (except A & B) blank
A2=25 B2=dogs D2=A2 all other columns (except A & B) blank
A2=25 B2=cats E2=A2 all other columns (except A & B) blank
and so on
 
try in C2
=if(B2="sheep",A2,"")
in D2
=if(B2="dogs",A2,"")
in E2
=if(B2="cats",A2,"")
and copy C2:E2
and paste as far down as you need
 
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

Copying formulas across columns 2
countifs Function not giving desired result with date criteria 2
Conditional sum, when condition has multiple values 3
More Planned and Actual Cycle Times 5
Generate Payment Due Date to exclude Weekends and Public Holiday 4
equals the actual number...not text ???? 7
concatenate problem 8
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula 2

Back
Top