study following formulae
=SUBTOTAL(109,[Column1])
how to possible all formula in drop down list?
Attached File : 577302 20150706213957 15413.xlsx downloaded: 250 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 Topic
- Dividend difference in 26AS, AIS, TIS
- 194JB INCOME
- Filing ITR3 where income under section 44AD with L
- What is superannuation fund
- GST Refund of input services under Inverted Duty S
- Dividend Reporting
- Real operational bottlenecks after firms use Tally
- Purchase return under gst
- Long Term Capital Loss - cannot be carried forward
- Cross-utilization of ITC between Trading and Resta
Related Topics
CAclubindia
