ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I've put data to columns - counted - need dropdown filter (https://www.excelbanter.com/excel-discussion-misc-queries/43420-ive-put-data-columns-counted-need-dropdown-filter.html)

vic 2005

I've put data to columns - counted - need dropdown filter
 
I've got a two columns spreadsheet with cells which have more than one set of
data in them. I've put column A from text to columns and managed to count
it, but now need to find out how to add the filter button at the top of the
column which enables me to filter according to number of names i want to see.
It is a name and address spreadsheet but the names and addresses are mixed
up, with some cells containing more than 5 names (column a) and some more
than 5 addresses (column b). i've sorted column a, but cannot find a unique
separator for column b.

please help me!!!


All times are GMT +1. The time now is 08:41 PM.

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