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: … Read more
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 … Read more
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 … Read more
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 … Read more
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. … Read more
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 … Read more
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 … Read more
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 … Read more
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 … Read more
Introduction ACS in excel is a text/string function. It is used in case of double byte character set to convert full width(double-byte) to half width(single-byte) characters. This function is useful for multiple languages and unique characters. For example, =ASC(“PRINCE”)gives PRINCE as the result. Syntax =ASC(Text) Arguments Text: It is the text or reference which contains … Read more