Is there a way to isolate or obtain the drop-down filter list in Excel (2007)?
When using the standard Filter function, a small GUI button appears at the top of the column to be filtered. Clicking the button causes a list to drop-down which displays every unique entry in that particular column. However, unlike the column itself in which a given entry can be entered repeatedly, the drop-down list displays each unique entry only once.
I can think of several situations in which having that type of list easily attainable, would be very helpful. However, does anyone know a quick way to create it?