Results 1 to 11 of 11

Thread: Counts min and max quantity of equals 'strings' based on a filter column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular
    Joined
    Jan 2015
    Posts
    98
    Location

    Counts min and max quantity of equals 'strings' based on a filter column

    Good morning


    in Excel 2021


    I need to count the minimum and maximum quantity of duplicate strings in J9:J70 according to the value in column H


    So in the attached example a formula placed in K3 should return 6, in L3 11, in M3 2 and in N3 9


    ...I don't know how to modify the formula I put in K3...


    Thanks if anyone can help me
    Attached Files Attached Files

Posting Permissions

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