Search results 60

  2. Search results
  3. Assumes list always have header row
Sorted from new to old.
Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25
Card image
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16
Card image
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3
Card image
GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5
Card image
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11
Card image
GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1
Card image
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27
Card image
Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13
Card image
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23
Card image
Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2
Card image
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29
Card image
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13
Card image
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6
Card image
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14
Card image
Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7
Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3
1234