column that has general information

  • Thread starter Thread starter araki
  • Start date Start date
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 :)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

column that has general information 1
copy multiple records based on criteria or total amount 22
Calculated Item causes undue repitition in pivot table 2
Excel 2002: How to lookup the last number and text in a column ? 3
Add columns to reach a predetermined value 2
Vlookup that only returns a value that satifies a condition. 9
Sequential numbering when X column repeats records 3
Comparing Workbooks 2

Back
Top