distinct rows in a seperate worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I need to select only distinct values from a column. Does anyone know how?
 
Hi
if you want to extract them use 'Data - Filter - Advanced Filter' and
check 'Unique entries'
 
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

Ignore Hidden Rows and Count of distinct values 3
Count Distinct Values based on criteria 4
Is there a function that counts distinct number od records in a ra 3
matching & combining data from seperate worksheets 2
Extracting duplicates with row ref's to a list 9
counting distinct entries with a qualification 7
Advice/best practice needed maybe some complex VB aswell 4
Returning row and column headers of a value 3

Back
Top