different views of data

  • Thread starter Thread starter Vinodexcel
  • Start date Start date
V

Vinodexcel

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

Dominic
 
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.
 
Back
Top