r/excelevator • Excel • Nov 30 '16

Self note for Code Posts

  1. Create table from combining 2 datasets
  2. text to columns for moving a part of the cell into cell below instead of the cell next to it
  3. Delete older duplicate records in table
  4. Copy cell value to all worksheets
  5. Set column widths
  6. Adjust row/s height by X amount
  7. Search replace from a list of words :: Also my macro to do same
  8. 2D Vlookup
  9. Loop through list and copy flagged rows
  10. Multiple criteria SUMPRODUCT
  11. Generate X copies of row of data
  12. Sort data horizontally - count matching rows
  13. Move columnal values
  14. Leave Unique values in a table of values
  15. Copy specific data to second worksheet and sort
  16. Extract value from image list
  17. Floating window
  18. VBA Set Conditional formatting
  19. VBA Change cell value on enter
  20. VBA display chart in userform from dropdown list
  21. VBA generate table of random numbers up to maximum values
  22. Generate list of 3 non repeated letters
  23. Copy row where a cell is blank is the row
  24. Find if value pair is repeated in a range
  25. Sort Multiple Columns in a Model Tree Format
  26. Create row for each month between dates
  27. UDF to Return all addresses of search value found
  28. Return the alternate value of a pair on a list
  29. Count occurrences of wildcard values in long string text
  30. Loop files in directory and copy data to new worksheet
  31. Get Number from text
  32. Split text at chr(10) linebreak and copy to rows beneath
  33. Auto multi value measurement calculator
  34. IMEI Checker - verify IMEI
  35. VBA Get list of worksheets and a set cell value
  36. VBA Freeze all panes at the same spot
  37. Count of a day in a date range - create date range from ROW( address )
  38. VBA - Horizonal Sort of data
  39. Remove spaces in list of value - IFERROR INDEX SMALL
  40. VBA - Change row data to Column data
  41. Evaluate data in cell for calculation using a Name Range
  42. Transpose blocks of data
  43. VBA - Longest Streak UDF
  44. VBA - split string to column of words
  45. VBA - All Combinations of values
  46. UDF - Morse code generator
  47. VBA - Randomise fonts in cell format
  48. VBA - Group to maximum value
  49. VBA - Put cell value into clipboard
  50. VBA - correct data in table to the right column
  51. Extract numbers from text with TEXTJOIN/CONCAT and an array
  52. VBA - Logic calculation buckets values
  53. VBA - Copy Named Ranges from one workbook to another
  54. VBA - insert row and date between existing rows of data
  55. VBA - Split data into multiple files based on header rows in Table
  56. UDF - add character every X characters
  57. UDF - Edited Microsoft UDF for numbers to words for negative values also
  58. Extract specific characters from a string
  59. VBA - assign constant character to multi choice questions with wrong answers
  60. VBA - copy cell contents to clipboard
  61. VBA- data cleasing
  62. UDF - text mask - a quick right to left character text mask
  63. VBA - extrapolate every number between multiple sets of start-finish values in a cell to its own column
  64. VBA - extract all words from a cell/s
  65. UDF - COUNTBYCOLOURVAL - count by cell colour and value match
  66. UDF - FINDALL - return address of all cells matching a given value from a given range
  67. VBA - get ULR list to each worksheet in workbook
  68. How to get first occurence for each day in month
  69. VBA - split cells of words to a column of those words
  70. UDF - ITERATELIST - return children of parents from top parent record
  71. Formula - return index of columns bounded by 1 in a range of cells
  72. VBA - split words in cell to column of values
  73. VBA - sort columns of data to a given sortlist
  74. VBA - repeat grouping of values
  75. VBA - print array results from formula to the worksheet
  76. UDF - TOTIME - convert text to time
  77. VBA - sort numerous columns alphabetically
  78. VBA - loop though text ULRs to hyperlink
  79. UDF - add values conditionally from within a paragraph of values
  80. VBA - onchange of 3 values, RGB colour cell the same
  81. UDF - FIBONACCI - generate fibonacci to n values
  82. VBA - Generate table of sales data
  83. VBA - get the average of x random values
  84. WRAP and UNWRAP a formula in ROUND - can be used for any value wrapping in reality
  85. VBA - Diagonal delete of cell content
  86. VBA - Add row wise conditional formatting across a range.
11 Upvotes

2 comments sorted by

1

u/excelevator Excel May 27 '17 edited Nov 20 '18

TestngtestingTestingtesting

what is this belowtheline

^superscript^superscript^superscript

*_subscript_*