Search results 79

Sorted from new to old.

UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

May12

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

May12

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

2024May27

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

1 2 3 4 5