Search results 60

  2. Search results
  3. column cells
Sorted from new to old.
Card image
Frm6 - ANmaMultiSelect

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

2021Jun23
Card image
SumOf_3Filters

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

2021Jan29
Card image
CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31
Card image
Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13
Card image
UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27
Card image
FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3
Card image
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3
Card image
all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22
Card image
Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3
Card image
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30
Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12
Card image
UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16
Card image
ChrW

Insert special characters inside Cell, using ChrW

2018Sep19
Card image
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5
Card image
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4
Card image
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30
1234