Browse by Tags

All Tags » Microsoft Excel (RSS)

Generating random question numbers for surveys or exams

I was recently asked to create a random question number generator in Microsoft Excel. The requirements were to create random question numbers from 1 to 65 that did not repeat. Here is the solution I came up with but I would interested to hear of any better...
Posted by gcastner | with no comments

Text manipulation in Microsoft Excel

Here are a number of simple but useful functions for manipulating text in Microsoft Excel. One potential use of these functions is to separate last and first name when they are stored in a single cell. An example Excel file is also attached. This formula...
Posted by gcastner | with no comments