How to delete all but specific data from a column

[eloisecate]

I'm trying to work out how to delete all information from a column excluding single value data. So for example I need to only keep the green and I can't think of a way to do this. There's roughly 25000 lines of data so going through manually is going to be a pain.

 

[Rick Rothstein]

Try this...
=UNIQUE(B2:B17,,1)

 

[SanjayGMusafir]

I need to only keep the green

What is the criteria to filter these records? There has to be some way to tell excel whom to keep

 

[eloisecate]

Thanks, I've got it all out now