10 ten list

[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?

 

[Peo Sjoblom]

Filter, press F5, special, select visible cells, copy, show all, paste in
the copied cells

 

[Peo Sjoblom]

Please refrain from posting attachments to a non binary newsgroup, if needed
contact OP and email or use a web interface where the OP can download the
file but better is to explain in plain words


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Zakir Ulla]

Hi,

didn't know the rules

Anyway, use the following method:

Formula = Large(Data,SlNo)

Data = the area that you want to lookup in, in this case the particular
column
SlNo= you could give reference to cell containing the serial number from 1
to 10

mail me to get a sample copy.

Kind regards,
Zakir Ulla
(e-mail address removed)

SLNo East West South North
1 =large(data,1)
2 =large(data,2)
3 =large(data,3)
4 =large(data,4)