Search results 98
ANmaRead_1stFile
Returns information about first file name found after sorting matching files in ...
HTMLTable_FullRow_NonBlanks
Returns all numeric values in row separated by Sepa Only cells that are not ...
ANmaSearch_OrFriends
Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...
Quarter1stLastDate_FromQuarterText
Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...
ANStr_Add10IfNotBlank_NorNA
Concatenate string into one, if not blank and not N/A It looked stupid for me ...
ReturnLongestString_Of2
Returns the string that is longer, comparing what is before StrSepa versus ...
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
NumberBeforeString_HTML
Cuts a number that would be found before certain word inside a block string. ...
PivotTable_ShowHideItems
Show or hide item (or items) in PivotTable for a certain field. Passing ...
PivotTable_ShowHideBlankItems
Shows or hides an item or items in a PivotTable filter field. Passing ...
SQL Cross Apply String_Split with XML Path
SQL select statement to convert list of IDs found in column (from more than row ...
ConcatenateStrings_AmongString
Collect strings matching search from a longer string. I used it to concatenate ...