Search results 28

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

Aug11

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

Feb20

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

ArrSort_4Arr

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

2023Apr14

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

1 2