ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Lists and filters (https://www.excelbanter.com/excel-discussion-misc-queries/257257-lists-filters.html)

Paul Peterson - Velox Consulting, LLC

Lists and filters
 
I would like to do the following:

1 - Allow a pre-set list of selectable values for a column of data - I'm
using the validation process so that is working.
2 - At the header level for this column of data, I'd like to be able display
selected values in this column, e.g., all rows with a value of "apple" in
this column. The filter works but I can't get it to work on multiple
columns. The list isn't working either.

Ideas?

Paul C. Peterson


All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com