Get the Sum of Filtered Data in Excel
Hello friends!! We’ll be learning to do calculation and do aggregation on filtered data in Excel. We’ll achieve this using the SUBTOTAL() function in Excel.
Read moreHello friends!! We’ll be learning to do calculation and do aggregation on filtered data in Excel. We’ll achieve this using the SUBTOTAL() function in Excel.
Read moreHello friends!! We’ll be learning quick way to convert Excel sheets to PDF in VBA . These quick VBA tip will help you to save lot of time.
Read moreHello friends! Today we’ll be learning how to send email from excel using HYPERLINK formula without VBA.
Read moreHello friends!! We’ll be learning few quick and very helpful Excel VBA tips & tricks. These few VBA tips will help you to save lot of time.
Read moreToday we’ll be learning how to consolidate multiple excel files present in a folder save the output file using VBA. We’ll use FileSystemObject in VBA to achieve this.
Read moreHello friends! It’s been very long I’ve written any article. I was super busy since last 4-5 months.
Hello Friends! What-IF Analysis is the way/process to check the affect of values in a formula.
Recently I came across a situation to find the row number for duplicate values.
In SQL Server there is a inbuilt function ROW_NUMBER() read more but in Excel there is no direct function as such.