in

ISOM Community

Communities for Grant's classes in information systems

Browse by Tags

  • 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 methods: Sub GenerateQuestions() ' Use Column...
    Posted to Duck Bytes (Weblog) by gcastner on 03-02-2007
  • 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 will return the first five characters from the...
    Posted to Duck Bytes (Weblog) by gcastner on 02-11-2007
Page 1 of 1 (2 items)
Copyright Grant Castner 2006 - 2007
Powered by Community Server (Commercial Edition), by Telligent Systems