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 |
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 |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com