Excel Formulas: Build Random Item Transaction History Data Using the Index Randbetween CountA Formula
For the past week or two, I have been working on building an online course through Udemy and it has been consuming most of my free time so I haven’t had a whole lot of opportunity to post anything here on my blog. That being said, I’ve been looking around for ways to generate random logical sample business data to help build up data sets and samples for my course. As a result, one thing that I’ve started to do is use the Index Randbetween CountA formula to pull data from one table located on a separate tab/worksheet that may hold a smaller set of data that will be required to build a full sample data set. (more…)
