How to use Excel LOOKUP function

Introduction LOOKUP function in excel is a lookup and reference function. This function is used to lookup or approximately match data in single column or single row and retrieve value from corresponding column or row. This function has two forms, one is called vector and the other one is called array form. Vector form Syntax  =LOOKUP(Lookup_Value, Lookup_Vector, [Result_Vector]) Vector form Argument Lookup_Value: Value that will be searched in the first vector. Can be text, number, reference etc.Lookup_Vector: It is the…

Continue Reading

How to use Excel TRANSPOSE function

Introduction TRANSPOSE function in excel is a lookup/reference function. This function is used to rotate or flip or switch cells and range of cells without duplicating the data. When copy and pasting of data is done, it leads to duplication of data, by using TRANSPOSE function this problem can be avoided. Syntax  =TRANSPOSE(array) Argument Array:  It is an array or a range of cells that will be transposed. A vertical range is converted into horizontal range and a horizontal range…

Continue Reading

How to use Excel ISOWEEKNUM Function

Introduction ISOWEEKNUM function in Excel is a type of DATE/TIME function. This function is used to find week number in ISO standard form (1-54). In ISO system, a week start on Monday and 1st week of the year always have a Thursday. For example, JAN 14 2018 gives 2 as the result when used in ISOWEEKNUM function. Syntax =ISOWEEKNUM(Serial_Date) Arguments Serial_Date- This is a Date in a valid excel format. Keynotes In General formatting of Excel, Dates are in form…

Continue Reading

How to use Excel GETPIVOTDATA function

Introduction GETPIVOTDATA function in excel is a lookup function. This function is used to return specific data from a pivot table. It uses pivot table structure instead of reference cell reference for retrieving data. Syntax  =GETPIVOTDATA (Data_Field, Pivot_Table, [field1,item1]) Argument Data_Field: It is the name of the field entered in quotation marks which contains the data to be returned.Pivot_Table:  It is the reference made to the cell in pivot table which has the data to be returned.Field_Item: These are pairs…

Continue Reading

How to use Excel MINUTE Function

Introduction MINUTE function in Excel is a type of DATE/TIME function. This function is used to find minutes from a given time. It gives result in form of numbers ranging from 0 to 59. For example, for time 10:15 AM, MINUTE function will retrieve 15 as the result. MINUTE function can also be used with the TIME function for feeding MINUTEs into this function. Syntax =MINUTE(Serial_Number) Arguments Serial_Number- This is time in a valid excel format or a cell number…

Continue Reading

How to use Excel TEXTJOIN Function

Introduction TEXTJOIN function are text/string function in excel. It is used to join multiple text strings with a delimiter attached to it. It also has option to ignore empty values and can also be used to join a range of cells. Syntax =TEXTJOIN(delimiter, ignore_empty, text1, text2) Arguments Delimiter: It is the separator between text values. Ignore_empty: Logical argument which decides whether empty values should be ignored or not. Text1: It is the first text or range. Text2: It is the…

Continue Reading

How to use Excel FIND, FINDB Function

Introduction FIND, FINDB in excel is a text/string function. This function finds one text string within another string and returns its position as a number. This is a case sensitive function. For example, if we have a text string in cell A4 and we wants to find the position of ‘P’ in this string, then we use the function =FIND(“P”,A4) and gets result in form of a number, if the text is not present, #VALUE error is displayed. Syntax =FIND(Find_Text,…

Continue Reading

How to use Excel YEAR function

Introduction YEAR function in Excel is a type of DATE/TIME function. It used to find YEAR of a specified date. It can be used to supply YEAR into a cell or used with functions like DATE function as a feeder. Syntax =YEAR( Date ) Arguments Date:- A date in a valid excel format. Can be entered using DATE function, If dates in form of text are entered then there is a possibility of getting an error.   Keynotes In General…

Continue Reading

How to use Excel YEARFRAC function

Introduction YEARFRAC function in Excel is a type of DATE/TIME function. It used to find year between two dates which can also be in form of a fraction and result can be in form of decimals. It is a worksheet function and can be entered in a cell. Syntax =YEARFRAC(Start_Date, End_Date, Basis) Arguments Start_Date:- A starting date in a valid excel format. Can be entered using DATE function, if dates in form of text are entered then there is a…

Continue Reading

How to use Excel HOUR Function

Introduction HOUR function in Excel is a type of DATE/TIME function. This function is used to find hours from a given time. It gives result in form of numbers ranging from 0(12:00 AM) to 23(11:00 PM). For example, for time 10:15 AM, HOUR function will retrieve 10. HOUR function can also be used with the TIME function for feeding hours into this function. Syntax =HOUR(Serial_Number) Arguments Serial_Number- This is time in a valid excel format. Keynotes Time values are represented…

Continue Reading
Close Menu
×

Cart