Source and Destination
Hi, all,
I would like a formula to do the following;
SOURCE DESTINATION
101 102
102 C 105
102 108
104
105 S
106
107
108 S
The source column A numbers run consecutively from 101-216. I just want any
column B source cell that has a C or S to have its 3 digit number appear
in destination column A. What formula do I use?
Thanks,
Malcolm
|