Filter Question

[Ray Batig]

Greetings,

I have a spreadsheet that I have applied the Data autofilter. When you click
a filtered cell, a list of one of every group of entries in the column pops
up. Does anyone know of a way to have this list pasted into rows of the same
column below the existing data entries?

Thanks for your help!

 

[Dave Peterson]

You have to do it yourself.

One way is to use data|filter|Advanced filter and choose Unique records only.

Debra Dalgleish shows how:
http://www.contextures.com/xladvfilter01.html#FilterUR

(You'll have to do it for each column in the range.)