Selecting specific numbers in a column among a long list of numbers

Hi there,

I am a fairly basic user so you might get a better answer from more experienced excel pros, but here is my contribution.

separators in filers do not work as it will look at each character, in other words excel views the ',' as a character not a separator.

What I would suggest is a separate column dedicated to filtering, then simply enter yes or no in it. Seeing as you have 15,000 rows I would suggest typing no into the forst row of the filter column and doing a fill command via the mouse (move mouse into bottom right of cell until a solid black cross then double click), this will copy that data where there is consistent data (eg column 2 with no spaces will result in copied from 1 to 15,000 however if there is a gap it will only copy upto the gap.

Then after you have copied that, jump to each of the 50 cells you want extracted and change them to a yes. Once you have done this select your filter dropdown, untick the no and there you have it (as per the attached).