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!

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.)



Ray Batig wrote:

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