I used this to get XPlus from around 180KB in size to around 60KB in size XMinifier: A small utility tool used to minify your VBA code.XDocGen: A documentation generator for VBA code making it easier to create documentation from your VBA code.XTemplate: allows the user to create templates in a Word, PowerPoint, or Outlook file that pull data from Excel files.My other project for Excel and the Office programs are: Also it is MIT Licensed, so you are free to use it for commercial and personal use. XPlus is written in pure VBA so its easy to embed in a spreadsheet and is only around 60KB in size, making it a very small addition to the spreadsheet. SUBSTR_SEARCH() -> pull the text within a cell between two characters you specify.RANDOM_SAMPLE_PERCENT() -> pull a random value in one range based on percentages determined in another range.SUMHIGH/SUMLOW() -> sums the top or bottom N largest or smallest values in the range.SORT_RANGE() -> sorts the range in ascending or descending order.FIRST_UNIQUE() -> returns TRUE for the first unique values in a range.
COUNTERRORALL() -> counts the number of errors in a range.SUM/AVERAGE/MAX/MINSHEET() -> performs a sum/average/min/max within a cell on all sheets based on partial sheet name.PARTIAL_LOOKUP() -> similar to VLOOKUP except does a lookup based best fit matches.My main project is an Excel function library, named XPlus, which contains over 100 functions in it. Hello r/excel, I'm a long time visitor of this subreddit, first time poster, and wanted to share a few of the projects I've been working on. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 kommentar(er)
