mahaveer dhelariya (devta) (practisioner) (692 Points)
06 July 2015
Kuldipsinh Jadeja
(Job)
(357 Points)
Replied 07 July 2015
There is a formula in MS Excel known as SUBTOTAL with different functions as follows :
Using this all functions of SUBTOTAL formula alongwith Data Validation function can help us to create such list. Also you can use INDEX go to the below link for detailed analysis :
https://blog.contextures.com/archives/2011/03/14/change-excel-function-with-subtotal/
Hope you got this stuff.
Excel Mastery Program
CAclubindia
