![]() ![]() The following refers to my "new" worksheet. ![]() So I have taken the liberty of redesigning the worksheet. Unfortunately, I do not understand what you are trying to do in columns F:L. And it makes it easy to switch between new random data and one or more snapshots. That ensures that we all see the same example. The advantage is: when we find the example that we want to discuss, copy-and-paste-value column N into column O, and change column B to reference column O with formulas of the form =O2. In a nutshell, the random data is created "on the side" (column N), and initially, the actual data (column B) references column N with formulas of the form =N2. So just right-click the tab and click Unprotect, if you wish. Note: I "protected" the worksheet so that I don't modify it accidentally. May I suggest an improvement? See the highlighted changes that I made in the "orig" worksheet in the attached file. And I'm happy to find someone (else) who knows how to create credible examples with "random noise". ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |