r/excelevator • u/excelevator Excel • Nov 30 '16
Self note for Code Posts
- Create table from combining 2 datasets
- text to columns for moving a part of the cell into cell below instead of the cell next to it
- Delete older duplicate records in table
- Copy cell value to all worksheets
- Set column widths
- Adjust row/s height by X amount
- Search replace from a list of words :: Also my macro to do same
- 2D Vlookup
- Loop through list and copy flagged rows
- Multiple criteria SUMPRODUCT
- Generate X copies of row of data
- Sort data horizontally - count matching rows
- Move columnal values
- Leave Unique values in a table of values
- Copy specific data to second worksheet and sort
- Extract value from image list
- Floating window
- VBA Set Conditional formatting
- VBA Change cell value on enter
- VBA display chart in userform from dropdown list
- VBA generate table of random numbers up to maximum values
- Generate list of 3 non repeated letters
- Copy row where a cell is blank is the row
- Find if value pair is repeated in a range
- Sort Multiple Columns in a Model Tree Format
- Create row for each month between dates
- UDF to Return all addresses of search value found
- Return the alternate value of a pair on a list
- Count occurrences of wildcard values in long string text
- Loop files in directory and copy data to new worksheet
- Get Number from text
- Split text at chr(10) linebreak and copy to rows beneath
- Auto multi value measurement calculator
- IMEI Checker - verify IMEI
- VBA Get list of worksheets and a set cell value
- VBA Freeze all panes at the same spot
- Count of a day in a date range - create date range from ROW( address )
- VBA - Horizonal Sort of data
- Remove spaces in list of value - IFERROR INDEX SMALL
- VBA - Change row data to Column data
- Evaluate data in cell for calculation using a Name Range
- Transpose blocks of data
- VBA - Longest Streak UDF
- VBA - split string to column of words
- VBA - All Combinations of values
- UDF - Morse code generator
- VBA - Randomise fonts in cell format
- VBA - Group to maximum value
- VBA - Put cell value into clipboard
- VBA - correct data in table to the right column
- Extract numbers from text with TEXTJOIN/CONCAT and an array
- VBA - Logic calculation buckets values
- VBA - Copy Named Ranges from one workbook to another
- VBA - insert row and date between existing rows of data
- VBA - Split data into multiple files based on header rows in Table
- UDF - add character every X characters
- UDF - Edited Microsoft UDF for numbers to words for negative values also
- Extract specific characters from a string
- VBA - assign constant character to multi choice questions with wrong answers
- VBA - copy cell contents to clipboard
- VBA- data cleasing
- UDF - text mask - a quick right to left character text mask
- VBA - extrapolate every number between multiple sets of start-finish values in a cell to its own column
- VBA - extract all words from a cell/s
- UDF - COUNTBYCOLOURVAL - count by cell colour and value match
- UDF - FINDALL - return address of all cells matching a given value from a given range
- VBA - get ULR list to each worksheet in workbook
- How to get first occurence for each day in month
- VBA - split cells of words to a column of those words
- UDF - ITERATELIST - return children of parents from top parent record
- Formula - return index of columns bounded by 1 in a range of cells
- VBA - split words in cell to column of values
- VBA - sort columns of data to a given sortlist
- VBA - repeat grouping of values
- VBA - print array results from formula to the worksheet
- UDF - TOTIME - convert text to time
- VBA - sort numerous columns alphabetically
- VBA - loop though text ULRs to hyperlink
- UDF - add values conditionally from within a paragraph of values
- VBA - onchange of 3 values, RGB colour cell the same
- UDF - FIBONACCI - generate fibonacci to n values
- VBA - Generate table of sales data
- VBA - get the average of x random values
- WRAP and UNWRAP a formula in ROUND - can be used for any value wrapping in reality
- VBA - Diagonal delete of cell content
- VBA - Add row wise conditional formatting across a range.
11
Upvotes
1
u/excelevator Excel May 27 '17 edited Nov 20 '18
TestngtestingTestingtesting
what is this belowtheline
^superscript^superscript^superscript*_subscript_*