extracting unique #'s from a list

  • Thread starter Thread starter matmich
  • Start date Start date
M

matmich

my last post was dealing with sumif function and you guys got me on th
right track. Now I have column with some duplicate #'s. How can
extract the unique numbers into a different column??

A1 B1
1 1
1 2
2 3
3 4
4 5
4 6
5
6
2
 
Hi!

Have a look at Data >Filter >Advanced Filter
It's pretty intuitive, but come back if you need more detail.

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

Scrabble Value calculation for Welsh words 0
Counting number of unique datafields in a column 1
Excel 2002: How to extract characters ? 5
Unique Cells 6
Unique #s in column, need multiple associated numbers in columns 5
extracting unique #'s from multiple columns 2
Counting Unique Pairs of Cells 6
Sumif want to sum a range bigger than one column 3

Back
Top