Hi, I'm trying to create a way to look at a column of Alpha-numeric product codes and fill another column with those items from the first one that that satisfy a particular condition
For example if the "population" column has a series of cells containing.....
N12111
M14999
N12987
A33001
N33444
N12555
A33888 etc.
and I want to pick out in the first cell the first item in the column that begins with "N12", then in the next cell I want the 2nd one, and so on.
The result in that case would be a list ...
N12111
N12987
N12555
and if I changed the criteria to looking for "A33" I'd get
A33001
A33888
any ideas?
For example if the "population" column has a series of cells containing.....
N12111
M14999
N12987
A33001
N33444
N12555
A33888 etc.
and I want to pick out in the first cell the first item in the column that begins with "N12", then in the next cell I want the 2nd one, and so on.
The result in that case would be a list ...
N12111
N12987
N12555
and if I changed the criteria to looking for "A33" I'd get
A33001
A33888
any ideas?