column that has general information

A

araki

Basically I have a column that has 6 or 7 different values:
TS,NT,PB,NN,LD,NU. All I want to do is get the records that are TS, NS,
NU. This will dramatically decrease the amount of records I need to
plot. I have about 500 total, so this will drop it to about 250-300.
Thanks,
Randy :)
 
A

AlfD

Hi!

Easy way is to use Filter > Autofilter. You can then copy the visibl
cells (select the cells: ctrl+C: F5: Special:visible cells only :OK
and paste elsewhere.

To leave a list in an adjacent column put =if(A2="TS",A2,"") in B2
assuming your list is in column A. Now copy B2 down as far as yo
need.
Col B will show all cells with TS. Same for other values.

Al
 
Top