Other Formulas

Convert column letter to column number	Other - Other
Convert column number to column letter	Other - Other
Find the cell address of the largest number	Other - Other
Find the position of the active worksheet in the workbook	Other - Other
Find the row of the largest number	Other - Other
Multiply numbers and sum	Summing - Other
Return a list of non blank items	Other - Other
Return a list of unique values	Other - Other
Return a list of unique values ignoring blanks	Other - Other
Return an array of worksheet names	Other - Other
Return the non blank items in a list	Other - Other
Return the workbook name from a full path	Other - Other
Sort into a random order	Other - Other
Sort using a custom list	Other - Other
Sort using one column	Other - Other
Sort using two columns	Other - Other

Convert column letter to column number Other - Other
Convert column number to column letter Other - Other
Find the cell address of the largest number Other - Other
Find the position of the active worksheet in the workbook Other - Other
Find the row of the largest number Other - Other
Multiply numbers and sum Summing - Other
Return a list of non blank items Other - Other
Return a list of unique values Other - Other
Return a list of unique values ignoring blanks Other - Other
Return an array of worksheet names Other - Other
Return the non blank items in a list Other - Other
Return the workbook name from a full path Other - Other
Sort into a random order Other - Other
Sort using a custom list Other - Other
Sort using one column Other - Other
Sort using two columns Other - Other

Convert column letter to column number

You can convert the column letter into its corresponding column number

	A
1	=COLUMN(INDIRECT("A"&"1")) = 1
2	=COLUMN(INDIRECT("B"&"1")) = 2
3	=COLUMN(INDIRECT("C"&"1")) = 3
4	=COLUMN(INDIRECT("Z"&"1")) = 26
5	=COLUMN(INDIRECT("AZ"&"1")) = 52

COLUMN
INDIRECT

Convert column number to column letter

You can convert the column number into its corresponding column letter.

	A
1	=SUBSTITUTE(ADDRESS(1, 1, 4), "1", "") = A
2	=SUBSTITUTE(ADDRESS(1, 2, 4), "1", "") = B
3	=SUBSTITUTE(ADDRESS(1, 3, 4), "1", "") = C
4	=SUBSTITUTE(ADDRESS(1, 26, 4), "1", "") = Z
5	=SUBSTITUTE(ADDRESS(1, 52, 4), "1", "") = AZ

ADDRESS
SUBSTITUTE

Find the cell address of the largest number

	A
1	ADDRESS( MIN( IF(cellrange = MAX(cellrange), Row(cellrange),"")), COLUMN(cellrange) )

Find the position of the active worksheet in the workbook

This formula returns the position of the active sheet in the workbook as an integer "=

	A
1	GET.DOCUMENT(87)", "=GET.DOCUMENT(76)".

Find the row of the largest number

	A
1	MIN(IF(cellrange = MAX(cellrange),Row(cellrange),"") )

Return an array of worksheet names

	A
1	RIGHT(GET>WORKBOOK(1),LEN(GET.WORKBOOK(1))-FIND("1",GETWORKBOOK(1)))).

This formula returns an array of worksheet names in the active workbook

Return the non blank items in a list

	A
1	Columns=3
2	Width=60
3	one
4	two
5
6	three
7	four

You can display a list of all the non blank items in a single column by using an array formula.
This single cell formula can be entered in the first cell and then dragged down.
If you are not using Microsoft 365 this formula must be entered with (Ctrl + Shift + Enter).
If you are using Microsoft 365 this formula can be entered without Ctrl + Shift + Enter, thanks to Dynamic Array Formulas.
Cells "A1:A5" displays our list, which includes some blank cells.
Cells "B1:B4" displays our list without the blanks.
Enter the formula into cell "B1" and press Enter.
Drag this cell (and its formula) down to cells B2, B3 and B4.
IF
IFERROR
INDEX
ISBLANK
NOT
ROW
SMALL
There are several Different Array Formulas that could be used.
NONBLANKVALUES - Returns an array of all the non blank items in a range.

Return the workbook name from a full path

	A
1	Book1.xls
2	C:\Temp\BetterSolutions.xls
3	C:\Temp\SubFolder\Another Folder\Workbook_Name.xls
4	=MID(A1,FIND("#",SUBSTITUTE("\"&A1,"\","#",LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))+1)),LEN(A1))="Book1.xls"
5	=MID(A2,FIND("#",SUBSTITUTE("\"&A2,"\","#",LEN(A2)-LEN(SUBSTITUTE(A2,"\",""))+1)),LEN(A2))="BetterSolutions.xls"
6	=MID(A3,FIND("#",SUBSTITUTE("\"&A3,"\","#",LEN(A3)-LEN(SUBSTITUTE(A3,"\",""))+1)),LEN(A3))="Workbook_Name.xls"

MID
FIND
SUBSTITUTE
LEN