Search results

Please let me know any shorter formula.Thanks for the support.

Wow excellent i got it.Thank you mercatog.

Dear Kaushik03, I read through the link already.But it doesnt suit me as my data is unique listing.

Thanks for your reply mercatog. But in column B,i have only 1 for B2,rest need to be derived.I need to put sorting based on the above solution.

Dear All, I need a formula help on the below data: RowA Apple grapes pineapple mango If i say grapes is "1" in B3,then data should be sorted as below: Grapes Pineapple Mango Apple Nee help on this please!

Thanks Luke.I will try this.Is there any quick solution?

Thanks Luke. I saw the link,but it takes lot of time to define names for each chart.is there any chance to create easily

Hi, I have a problem of updating chart every month.I usually make a presentation for year (trailing 12 months)and i need to update data each month for chart.Data's are different and i need to present nearly 75 charts. For Example, Chart1 - Revenue - Trailing 12 months Chart2 - Cost-...