How to use the Match function in Excel
Match function allows you to quickly locate for a specified item in range of cells and then returns relative position of that…
#Excel
189 postsExcel DatedIF function Compare between two dates
DatedIF function is quickly get difference of days, months or years between given two dates. DatedIF is categorized as a Date/Time Function.
How to lookup images in Excel using Index Match function
If you need to lookup images in Excel then you must have to use Index Match function to quickly get the result…
How to use the Excel AVERAGEIF function
AVERAGEIF function in Excel is used to returns the average (arithmetic mean) of all the cells with in the range which meet…
VLookup to Get Sum, Average, Count, Maximum and Minimum value from Multiple Columns
If you need to calculate the Sum, Average, Count which condition. Then apply VLookup to get Sum, Average, Count, Max and Min…
VLookup Function in MS Excel with Appropriate Match
Search value as per given condition in table or array by VLookup Function in MS Excel with appropriate match option for searching.
How to link data between two or more workbook in Excel
This guide allows different ways to link data between two or more workbook in Excel. You can establish, remove, edit and refresh…
How to use DCOUNTA Function in Excel
With the help of DCOUNTA function you can easily count all those non-blank cells which match the criteria in active database.
How to switch or flip name in Excel
Switch or flip name in Excel sheet. With helps of excel function, you to quickly reverse the first name and last name…
How to turn on or turn off scroll lock key
Guide: During working on the Excel sheet you can easily turn on or turn off scroll lock key in Windows Operating System.