Return only if same

[JulieD]

Hi

in B1 type
=IF(A1="lorry",A1,"")
and then fill down the list by putting the cursor over the bottom right hand
corner of the cell and when you see + double click

Cheers
JulieD

 

[Pat]

Example :

A1 =cars B1 =(empty)
A2 =lorry B2 =lorry
A3 =tractor B3 =(empty)
A4 =lorry B4 =lorry

Column B contains a formula which will retun lorry as the result. The
formula in B1 will look something like this:
B1 =if(A1),="lorry",A1
Because A1 does not contain "lorry" then the cell will return nothing or
(empty) as shown.
B2 =if(A2),="lorry
Because A2 contains "lorry" then the cell will return "lorry" as shown.


Hope someone can help with this.
Thanks
Pat