Text cells in Excel, crosstabs? drilling down? Conversion?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jim (jbarenie_at_mail.mcg.edu)
Date: 05/17/04

  • Next message: John Nurick: "Re: Text cells in Excel, crosstabs? drilling down? Conversion?" 
    Date: Sun, 16 May 2004 18:27:35 -0700

    I have a workbook with 100 identical format worksheets.
    Each work*** is an educational course. There are 25 row
    labels down the left representing 25 different
    competencies we need to teach. There are about 12 column
    labels to indicate if the course helps teach the
    competency and how it is measured if it is taught (such as
    written exam, oral exam, lab practical, specific
    competency on patient care, etc.) The cells only have
    text data (many cells have no data whatsoever). Is there
    any way to take advantage of something like a crosstab for
    numerical data using excel? If excel cannot do this, is
    there a way to import a 100 work*** file into Access to
    do something similar? Thanks for any suggestions.

    Jim

  • Next message: John Nurick: "Re: Text cells in Excel, crosstabs? drilling down? Conversion?"
    • Quantcast