study following formulae
=SUBTOTAL(109,[Column1])
how to possible all formula in drop down list?
Attached File : 577302 20150706213957 15413.xlsx downloaded: 266 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 Topics :
- GST Return
- Practical queries on buy back of shares
- Any faculty recommendations for latest batch recor
- FAI & FAST-DS 2026 query
- Is GST registration mandatory in this case
- Buying a residential flat in Goa: should my wife b
- Income tax filling
- Applicability of RCM in the case of import of serv
- Confusion in gst registration for service category
- Itc claimed from return defaulters
Related Topics :
CAclubindia
