Alter
- 01) Sort Selected Cells Based on up to 9 Columns
- 02) Sort Selected Cells Based on Text and Cell Color
- 03) Insert Row on Change
- 04) Segregate Found Item
- 05) Remove Empty Rows From Selection
- 06) Gather Rows Matching This Cell
- 07) Paste Your Copied Cell and Skip the Blank Lines
- 08) Fill in The Blanks By Using The Value From The Above Cells
- 09) Convert Possible Dates Found Within Selected Cells to Either Text or Julian
- 10) Write label ‘EOT’ to select cells. Only populates blank cells.
- 11) Convert Asterisks to Dashes 123456*1 becomes 123456-1
- 12) Resets the Used Range for the Current Tab
- 13) Re Enter The Cells Value Allowing it to Pick Up the Underlying Format
- 14) Flip the Sign on Each Cell Within Selection
- 15) Transposes Data. Select the entire column(s) for the base data, then select the header cells. Will Remove Zeros and Blanks
- 16) Transposes Data. Select the entire column(s) for the base data, then select the header cells. Will Zeros Fill Blanks
- 17) Complex Data Fill In (VLOOKUP on Steroids)
- 18) Sorts the selection based on the first 26 columns A-Z
- 19) Add $ (anchors) to selected formula
Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc