Dynamic Ranges

[Raghunathan]

Hi,

Greetings.

After very long time, am visiting this cite. Now look and feel of the site is wonderful as compared with the previous one.

Seek your support for the following situation.

I have a master table which is running multiple rows and column.

From the master table, i have extracted the data for dynamic ranges (Ref. Table1 in the attachement) which is not sorted in any order. I have used array formula for extracting from the master table.

But I need sort the data in one column and that will be used as a dynamic ranges for the graphs/charts. (Ref. Table 2)

I tried index & match function, But i found it is working properly, in case the lookupvalue is repeated.

Looking forward to your help.

Thanks

Raghu

 

[NARAYANK991]

Hi Raghunathan ,

I am not able to understand your requirement ; are you saying that in Table 2 you want the data to be sorted on column J ?

Will this be a one-off requirement , or can the column change to G , H or I ?

If it is an interactive chart where the sort column can be different based on user input , then it is better to have a macro based solution ; when ever the user changes the selected column , a macro runs changing the sort order.

Narayan

 

[Somendra Misra]

Hi Raghunathan,

See the attached file (Yellow Cells)

Regards,

 

[Raghunathan]

Mr. Misra,

Sorry being respond to you late.

Thanks for your support. It is working good.

Regards

Raghuathan S