While you could do this using VBA (I thought of a rather complicated solution to do this) it's MUCH easier to just use power query and use multiple filters. I also read an example of someone trying to use a multi-column filter in Excel. However, this complex modeling could have been done using the Solver add-in, which is native in Excel but must be enabled from the addins. I read someone trying to do a complex modeling using VBA even though they had little background. I posted this a few days ago in the VBA subreddit:Ĭertain solutions that you think might need VBA solutions may have solutions in Excel where no VBA is required. Before all of that.I only knew Excel and my secret weapon was INDEX/MATCH. My life changed that day that I went to python, because it led me to SQL, Django, and now I'm self-teaching SSIS with SQL Server. However, some problems are just quicker to solve using VBA or basic excel functions.Īnyway, I hope you find what you’re looking for and it turns out even better for you. So far I haven't come across a problem that I can't solve with python. I ventured into pandas after learning how to read and write excel files with python. Then I was introduced to PANDAS for python. I started with a real problem that I had at work and built my solution in small pieces. The nice thing about python is that it's relatively easy to get started. I had intended to learn more, but realized that python can accomplish the same goals and much much more. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown.īefore I was introduced to python, I took that Intro to VBA mooc program that shows up in this thread periodically. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data.
You can select code in your VBA window, press Tab, then copy and paste into your post or comment. To apply code formatting Use 4 spaces to start each line 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
Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 kommentar(er)
