study following formulae
=SUBTOTAL(109,[Column1])
how to possible all formula in drop down list?
Attached File : 577302 20150706213957 15413.xlsx downloaded: 260 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 :
- Can I pursue articleship alongside a regular full-
- Investment fund's income from ncd distribution to
- Comparative BS PL with Audit report
- Source of funds in IT returns
- Work from home job
- TDS ON ANY PURCHASE OF ANY GOODS - 393(1)
- TDS on payment to a non resident
- NSFA(National Food Security Act) commission
- RCM applicability on petty GTA freight (₹450
- Short payment reccieved in export & GST implic
Related Topics :
22 September 2026
Account Assistant
Chirag P Shah & Co. Chartered Accountant
Pune
B.Com
View Details
ARTICLESHIP
21 September 2026
CA Article Assistant
KK & Company Chartered Accountant
Pune
CA Inter
View Details
ARTICLESHIP
30 September 2026
CA Article Assistant
CA Suraj Garg & Associates
New Delhi
CA Final
View Details
Featured
12 September 2026
Assistant Manager - Finance & Compliance
Naveen Fintech Pvt Ltd
Kolkata
CA Inter
View Details
CCI
Pro
CAclubindia
