study following formulae
=SUBTOTAL(109,[Column1])
how to possible all formula in drop down list?
Attached File : 577302 20150706213957 15413.xlsx downloaded: 236 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
- Form 121 requirement
- Interest on reversal of ITC when ITC balance avail
- Is MirrorFly an Instant Messaging Software?
- ITR filling for legal heir
- How Can I qualify CA Final Exam?
- Wrong reporting on 22 april 2026 under article inc
- Articeship Form 107
- TAN for Multiple States
- Delivery Challan serial number Issue and return ru
- After filing form 71 For TDS mismatch
Related Threads
CAclubindia
