Maybe you don't need to sort them.
You could select all your range and do Data|Filter|autofilter.
Then you could use the dropdown in the customer column to show Mike.
==
But you could select your range and sort by the customer column--then all the
rows with Mike as the customer will be grouped together. You could even provide
a secondary key of Bank to get that in alphabetical order, too.
Vinodexcel wrote:
>
> Hi - I desperately need help. Below is an example of data I am working
> with
>
> On the left hand side you have a list of banks. Against them customers.
> 1 customer can appear against different banks. How can I sort data to
> view it customer wise?
>
> Bank Customer
> ------ -------------
> HSBC -- Mike
> Tokyo Bank -- Stan
> Stan Chart -- Mike
>
> In the above example, I need to sort by Mike - HSBC & Stan Chart should
> show up.
> Thanks in advance. Regards, Vinod
>
> --
> Vinodexcel
> ------------------------------------------------------------------------
> Vinodexcel's Profile: http://www.excelforum.com/member.php...o&userid=16688
> View this thread: http://www.excelforum.com/showthread...hreadid=470782
--
Dave Peterson
Similar Threads
