different views of data

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

Good afternoon Vinodexcel

It sounds as though you need to use the autofilter.
Data > Filter > Autofilter.

HTH

DominicB

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