Excel Format Help

[Lasantha]

Hi Team,

Please look into the attached file. I need your help to convert "Data" sheet's details according to "Format" sheet .

Kindly look into this and help me.

Thank you,
Lasantha Karunarathne.

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Lasantha]

Thank you Narayan, Appreciate your help with this.

 

[Lasantha]

Hi Narayan,
How to copy formula if I have more than 100 records. I dragged formula to other cell, but didn't work. Can you please help me again.

Thank you,
Lasantha.

 

[NARAYANK991]

Hi ,

See this file.

You don't have to copy formulae or do anything other than add data ; as long as your data is less than 150 rows , everything should work.

Narayan

 

[Lasantha]

Thank you Narayan.