How to fetch particulars rows & columns

[Bipin619]

Dear Sir,

I have large amount of data in excel sheet arranged as given below.
IndAprMayJuneJulyAugSeptOctNovDecJanFebMarch
Sale
purchase
exp
profit

USAprMayJuneJulyAugSeptOctNovDecJanFebMarch
Sale
purchase
exp
profit

UKAprMayJuneJulyAugSeptOctNovDecJanFebMarch
Sale
purchase
exp
profit

So on


how can i apply filter in such a way that i can get data of say ind with click or say uk with on click

 

[Chihiro]

Not an ideal data structure. But you can use "Group" tool available in Data ribbon tab, under Outline.

 

[Bipin619]

Thanks for reply Chihiro
I know it's not ideal structure but this is specific format i can't change it.

But using group how can i get data region wise ?
I want to create one dynamic filter so that i can get region wise data in one go

 

[Chihiro]

Not sure what you mean by get data in one go.

You just want to quickly navigate to data? Or do you need to display it else where?

Upload sample file to get better help.

 

[narunfca]

Enclosed the example file using INDEX and MATCH.
Hope this helps.

with best regards
Arun N

 

[Bipin619]

Thanks you so much Arun Sir for solving my query.

your file was very helpful.

Also thank you chihiro sir for taking active part in my query.