Search results 116

Sorted from new to old.

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

2022Sep1

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

tag_add

Add to textbox from listbox (select option) ensure its uniqueness

2021Aug24

1 2 3 ...7 8