Precise file Link below

https://www.mediafire.com/file/xq26d8343q2jawk/10+New+Excel+Formulas.xlsx/file

Notes

VSTACK Function :-

The VSTACK function lets you combine cell ranges or arrays, it joins data to the first blank cell at the bottom of a cell range or array. The VSTACK function is designed to allow you to combine data from multiple tables/ranges.

The Syntax of VSTACK is = Vstack (array1,array2,….)

HSTACK Function :-

HSTACK returns the array formed by appending each of the array arguments in a column-wise fashion. HStack positions views in a horizontal line, VStack positions them in a vertical line.

The Syntax of HSTACK is = Hstack (array1,array2,….)

TEXTBEFORE Function :-

TEXTBEFORE function in Excel is designed to extract text before a specific character or substring, known as the delimiter.

The Syntax of TEXTBEFORE is

=TEXTBEFORE(text, delimiter,[instance_num], [match_mode], [match_end], [if_not_found])

TEXTAFTER Function :-

TEXTAFTER function returns text that appears after a given character or substring, which is called the delimiter.

The Syntax of TEXTAFTER is

=TEXTAFTER(text,delimiter,[instance_num], [match_mode], [match_end], [if_not_found])

TEXTSPLIT Function :-

TEXTSPLIT function works the same as the Text-to-Column’s wizard, but in formula form. It allows you to split across columns or down by rows. 

The Syntax of TEXTSPLIT is

=TEXTSPLIT(text,col_delimiter,[row_delimiter],[ignore_empty], [match_mode], [pad_with])

TOCOL Function :-

TOCOL function in Excel converts an array or range of cells into a single column. 

The Syntax of TOCOL is

=TOCOL(array, [ignore], [scan_by_column])

1 Ignore Blank Cells

2 Ignore Errors

3 Ignore Blank Cells & Errors

TOROW Function :-

TOROW function in Excel converts an array or range of cells into a single row.

 The Syntax of TOROW is

=TOROW(array, [ignore], [scan_by_row])

1 Ignore Blank Cells

2 Ignore Errors

3 Ignore Blank Cells & Errors

TAKE Function :-

TAKE function extracts the specified number of contiguous rows and/or columns from the array or range.

The Syntax of TAKE is

=TAKE(array, rows,[columns])

DROP Function :-

The DROP function removes rows and columns from the array’s beginning or end.

If you input positive numbers for rows or columns while using DROP, it will remove values from the beginning or top of the array.

The negative numbers are used as an index to remove values from the end (bottom) of the array.

The Syntax of DROP is

=DROP(array, rows,[columns])