Hey Everyone. Take a look at this pic (Hope this works).
Column A is a formula for Columns B:D. When I randomize A:D, my results yield what you see in F:J (Just ignore Column G as I inserted it stricly for aesthetic reasons after the randomization. But what I really want in Column F is what you see in Column L. I want the formulas to point to their original cell contents no matter where they are randomized to. Anyone have any idea how to do this? I've tried $ signs in front of them, I've tried different cell randomization to no avail. Anybody? I sure could use some help on this. I've racked my brain for hours and hours. I don't even know what to search for to ask the right questions. Please help. Thank you.
Spreadsheet Sample.jpg
Bookmarks