| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Analysis
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 |
|
#2
|
|||
|
|||
|
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 "sirgresley" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
| Analysis ToolPak installed but no Data Analysis option | Excel Discussion (Misc queries) | |||
Hybrid Mode
