study following formulae
=SUBTOTAL(109,[Column1])
how to possible all formula in drop down list?
Attached File : 577302 20150706213957 15413.xlsx downloaded: 251 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 :
- Free CA Foundation Study Material - PYQs with Sugg
- INCOME TAX
- Moving from old to new tax regime after notice
- Need urgent help on notice
- ITR-3 - F&O Loss adjusted against business inc
- Error - Blank Rows in Schedule SI (ITR-2)
- Dividend from co-operative society
- SECTION 139(10) OF THE COMPANIES ACT, 2013 CASE
- TDS u/s.194C returns filed in ITR-1
- TDS on Property - Form 26QB Related
Related Topics :
CAclubindia
