Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2005
    Location
    North Carolina, USA
    Posts
    195
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Frequency of text entries (Excel 2003)

    Hello again,
    I need help on determining what the 2nd most frequent text entry in a column is. I attached a sample with my predicament. At the bottom of the sheet it should display the most frequent incorrect answer (shown in red) to each question in a multiple choice test. Any help would be appreciated =)

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Frequency of text entries (Excel 2003)

    In <post#=504,430>post 504,430</post: >, I asked you
    <hr>Note: the workbook you attached contained an empty VBA procedure. Unless it's necessary for the question, it's better to attach files without macros.<hr>
    You again included VBA code unnecessarily. Please don't!

    In the attached version, rows 78 through 81 have been used to count the number of incorrect As, Bs, Cs and Ds. per question. You can hide these rows if you like. The formulas in row 77 return the most frequent incorrect answer. If there is a tie, which happens often, the first one of the incorrect answers with the maximum frequency is returned.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •