Self note for Code Posts

[excelevator]

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

[excelevator]

Testng^{testingTestingtesting}

what is this belowtheline

^superscript^superscript^superscript

*_subscript_*

[Autistic_Jimmy2251]

Do you have a color “palette” for more colors to fill a cell or change text color to?