Search results 63

  2. Search results
  3. items
Sorted from new to old.
Card image
CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

Oct24
Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Oct6
Card image
ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30
Card image
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29
Card image
ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

Apr15
Card image
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8
Card image
ANStrSort3

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

Feb20
Card image
Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

Feb5
Card image
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23
Card image
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22
Card image
CutString9

Cuts from CutFrom starting from any of items found from ...

Jan7
Card image
CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1
Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22
Card image
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19
Card image
Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16
Card image
MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20
1234