T
trevor.sandler
Hi everyone,
I have a file that has customers names in column A - 6,000 + lines of
customer names for all sites across the country.
Column heading going across are branch names and the numbers inserted
in each cross cell (ie customer name and branch name) reflect number of
units sold for that customer at a particular branch.
I now need to filter the data so that the top 10 customers (by units
sold) show up for each site.
My problem is that when I filter column B for top 10, filter hides all
other customer names.
Is there a way to do a top 10 filter across adjacent columns where the
filter is independent of other columns?
I have a file that has customers names in column A - 6,000 + lines of
customer names for all sites across the country.
Column heading going across are branch names and the numbers inserted
in each cross cell (ie customer name and branch name) reflect number of
units sold for that customer at a particular branch.
I now need to filter the data so that the top 10 customers (by units
sold) show up for each site.
My problem is that when I filter column B for top 10, filter hides all
other customer names.
Is there a way to do a top 10 filter across adjacent columns where the
filter is independent of other columns?