Sumit... Love your videos. Is there a way to use a ListBox control on the spreadsheet and then use the selected item in the listbox as your filter criteria?
Hi Sumit, I have a large table setup with lots of blank cells in other columns. Somehow, once I applied Advanced filter, the blank cells will have value paste in by Excel, do you know how can I avoid that?
The trick is: apply a filter to the range you want to sum; while the range is filtered, use ALT+= to autosum the column at the last cell in the range; since you have a filtered range, autosum will enter the SUBTOTAL() function instead of the SUM() function. You can then unfilter your range and the SUBTOTAL function remains. For Filter/Unfilter, have the active cell within your range of data and press CTRL+SHIFT+L. It is a toggle.. so.. goes on if it is off.. goes off it is on. If you need more description, check out this link: www.excelcampus.com/keyboard-shortcuts/autosum-subtotal-formula/ Hope this helps. Good luck!
Thank you . Excellent. Your explanation is very simple, easy to understand, and it is of great use to the Excel learners. Doing a great job indeed. Your contact no. please, for learning vba
Hi Sumit.. thanks for this summary of Data Sorting and Filtering. Thumbs up!
hello from 2023 and still your videos are amazing we appreciate it.
hanks for ur time and for sharing ur works free.
I had not seen the "Advanced Filter" option before. GREAT feature. Will really simplify one of my projects. Thanks for the video1
Thanks for the this course.
Great video . Learnt
Sumit... Love your videos. Is there a way to use a ListBox control on the spreadsheet and then use the selected item in the listbox as your filter criteria?
amazing
plz provide practice sheet also i am not able to access it on ur website
Thankyou.....its really very helpful....
Where i will get excel file for study and practice
What Buttons did you Press on 11:30?
Hi Sumit, I have a large table setup with lots of blank cells in other columns. Somehow, once I applied Advanced filter, the blank cells will have value paste in by Excel, do you know how can I avoid that?
Use paste special...and select skip blanks
Dear sir.
I want to know keyboard shortcut for subtotal function. Thank you in advance.
The trick is: apply a filter to the range you want to sum; while the range is filtered, use ALT+= to autosum the column at the last cell in the range; since you have a filtered range, autosum will enter the SUBTOTAL() function instead of the SUM() function. You can then unfilter your range and the SUBTOTAL function remains. For Filter/Unfilter, have the active cell within your range of data and press CTRL+SHIFT+L. It is a toggle.. so.. goes on if it is off.. goes off it is on. If you need more description, check out this link: www.excelcampus.com/keyboard-shortcuts/autosum-subtotal-formula/
Hope this helps. Good luck!
U are the best
thanks!
will u plzz zoom the data
Sir 🙏
I want to extract data by using of advance filter of any month from the date (format dd/mm/yyyyy) table.
How do it do?
Thank you . Excellent. Your explanation is very simple, easy to understand, and it is of great use to the Excel learners. Doing a great job indeed. Your contact no. please, for learning vba
Welcome to online class 101
data is not clear