Most of the time, we need to look up values based on multiple column criteria. However, the standard VLOOKUP function allows searching based on a single column with a single criterion. In this article, we will explore how to perform lookups with multiple column criteria using the powerful combination of the INDEX and MATCH functions. […]
Continue Reading
We will be going to see the new user-defined Excel Functions (UDF). This Function can retrieve Numbers from Text String. Most of the time we required number values from text strings, In that case this function is most useful. What is name of this Function ? This functions name is = NumFromTxt_UDF(Cell_reference). Does this function […]
Continue Reading
We will be going to see the new user-defined Excel Functions (UDF). These functions can sum by Background Color or Font Color as well as can count cells by Background color or Font Color means sum by color and count by color. If you work with Excel and often use color to organize your data, […]
Continue Reading
If you want to import excel Table into SQL Database. You are at right place. Most of the time we required to import Excel Data into SQL (Like MySQL Database), and conversion is not easy task. We have prepared Customized fuction for you (called User Defined Function (UDP). This function wraps selected range Row into […]
Continue Reading
You want to combine all cells value scattered in rows and columns. But you dont want to select each cell seperate by comma, then you are at right place. We have designed a function for you which can combine / concat all value by just selecting range inside the function. =AllConcat(A2:D7) Copy above function inside […]
Continue Reading
If you want to copy Display value in Excel which different from the actual value in Excel. You are at right place. Most of the time with format cell option we can change display of actual value, but there is no option in excel to copy the same value to another cell as original value. […]
Continue ReadingExcel Function – SUMIF Next version – sumifcr with multiple criteria With this function we can sum with multiple criteria in single cell. It has three variable, ‘a = criteria range TEXT format ‘b = sum range NUMBER format ‘c = criteria, comma separated TEXT format Copy this function use it anywhere in excel file.
Continue ReadingExcel Function with range selection. Finally, Assign out to function name variable (abc as string), to get output in cells.
Continue Reading
Excel VBA Save as VBA at Required path. Following is the code to save pdf Before this check Option in Save As menu – File type = PDF. Enjoy!!!
Continue Reading
When we use excel most often shortcut keys speed up our working. Most ofter used shortcut keys in excel as follows – To Auto Filter on /off = ctrl+shift+L This key will activate filter at the top of selection. Same key will be useful to deactivate filter. To Select only visible cells = Alt+; This […]
Continue Reading