List Containing Instances of Numbers in a group

M

MrvinGover

Is it possible to have excel return a list of numbers that occur in
group of numbers? For example

I have a list like so;

153110
153110
153110
153110
153114
153114
153114
155040
155199
203210
203220
203220
203220
205065
223110
223110

And i would like a returned list like so;

153110
153114
155040
155199
203210
203220
205065
223110

Where every instance of a number is listed.

Any Ideas
 
M

MrvinGover

I think i found a better alternative.

Select Range, Click Data>Filter>Advanced Filter

And click Unique Records only

And it specifies a location to copy the results to.

Violia
 

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

Database Sum Question 4
How can the font and size of (all) citation numbers be altered? 1
Excel does not accept text format! 0
Space at end of multi page list to accommodate new entries 1
Section and Page numbering 0
Finding the proper style field and the numbered paragraph value within the style 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Finding the right style field in VBA 0

Top