Results 1 to 2 of 2

Thread: Count the max frequency of a number

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Count the max frequency of a number

    Dear Everybody,

    In attached file, I meet 2 problem:

    1. In Part I- Only 0 & 1: The formula give the correct result. But when I change 1 to a number >0, I do not get correct result.

    2. In both Part I & II, I have to put "" in blank cell to get correct result for Formula in B & D column.

    Please help me to solve these problems.

    Thank you so much.
    Attached Files Attached Files

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Brussels Belgium
    Excel Version
    2010 on Xubuntu

Posting Permissions

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