Sort data on variable period range to make table

[sureshgilda]

Sort data on variable period range to make table

 

[Lutfor Rahman Shimanto]

Sort data on variable period range to make table

Hello Suresh Gilda

Welcome to ExcelDemy Forum. I am delighted to inform you I have fulfilled the requirements you describe within the workbook.

The requirements are achieved by developing many complex Excel Formulas and Conditional Formatting. Besides, I reorganized your sheet structure to reach your goal. It took several hours to complete the work.

OVERVIEW of Desired System:

​

To develop such a system or make it even more attractive, you can contact Excel Consultancy Services of ExcelDemy. Good luck!

Regards
Lutfor Rahman Shimanto
ExcelDemy