study following formulae
=SUBTOTAL(109,[Column1])
how to possible all formula in drop down list?
Attached File : 577302 20150706213957 15413.xlsx downloaded: 207 times
Menu
How to possible all formula in drop down list?
Replies (1)
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.
Recent Threads
- Whether GST applicable on Hardship Compensation pa
- ITC cannot be denied to Bona Fide Buyers for Suppl
- Unused ITC for Hotel after GST Change
- CA FINAL SPOM
- 44ad presumption of tax
- Friendly loan to blood relative?
- Tds penalty for in operative pans
- TDS on Property- 26QB filing Doubt
- HSN code for Exempted supplies
- HSN Summary of Outward Supplies (Sales and Advance
Related Threads
CAclubindia
