Hi muthomi kiragu
Welcome to Excel Forum

This is just the Sub Forum to say hello
Unfortunately you are posting incorrectly ( and have Possibly in your haste have not read the Rules which you agreed to on registering. This makes it difficult for the people here to help you, many of which will likely be keen to do so )

You must start a new Thread here if you need help:

http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/

If you are not sure, then probably the first will do
http://www.excelforum.com/excel-general/

_............................................

Please, also, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
http://www.excelforum.com/showthread...09#post4494031
It is usually worth it in the long run.

Thanks

_..............................................

P.s. Unless someone is very familiar with having done something exactly as you are doing, then I think you may need to give a bit more detail. Some test data is helpful
Remember to reduce the amount of test data to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
Show us clearly what you have and the results you want to achieve.
Please do not use images as we cannot copy them to a worksheet.

Some ways to do this ( Most people here upload a Workbook )
Either:
Post screenshots COPYABLE to a Spreadsheet: – See my signature below,
or here:
http://www.excelforum.com/excel-prog...ml#post4399581
Practice here:
http://www.excelforum.com/development-testing-forum/

OR:
Upload a Workbook: See here:
http://www.excelforum.com/the-water-...his-forum.html ( Method 2 and Method 3 )
http://www.excelforum.com/suggestion...ml#post4335120
OR:
There is also the file share site option such as this free thing:
https://app.box.com/signup/personal
(_ .Remember to select Share after uploading and give us the link they provide if you use that )
But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags # )

OR:
Select the table Icon above, select an appropriate size table and fill it in (If replying to a Thread you may need to select the Go Advanced Button, ( bottom right of reply Window ) to get the Table Icon to show )


Practice Posting techniques here:
http://www.excelforum.com/development-testing-forum/

Thanks,
Alan