Excel 2007 : Concatenate

[manishcfa]

Hi,
I want to write a statement through concatenate function which look like this "The country america contributes 10.83 %in total revenue of the company followed by canada(10.61), brazil(10.4), uk(10.18), japan(9.96), india(9.75), sri lanka(9.53), nepal(9.31), holland(9.1), india(5.01), ....... etc." However it may happen sometime that number of country is more than whats in example or less in example. I want excel to automatically write the required statement correctly. Alongwith it is it possible to come out with result as given in attached excel with all calculation done automativcally like total revenue calculation or percentage caluclation upto two decimal place.
Please help.

[rethguals]

hi..
it's simple user defined function
check attachment please!

Please Login or Register  to view this content.

[manishcfa]

Hi Friend
Thanks for your reply however friend I don't know anything about VBA and so I could not understand the hard work done by you. Can you make it simpler or complex to make it easier for me. I have no rights to say this to you but if you can do it it will be of great use to me.
Thanks a ton for your help
Manish