List Containing Instances of Numbers in a group

  • Thread starter Thread starter MrvinGover
  • Start date Start date
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
 
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
 
Back
Top