+ Reply to Thread
Results 1 to 12 of 12

please, detect the quantity of each group in the list

  1. #1
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,651

    please, detect the quantity of each group in the list

    please, detect the quantity of each group in the list
    https://www.excelforum.com/attachmen...1&d=1547629654
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    714

    Re: please, detect the quantity of each group in the list

    where is the list?
    exlplain clearly
    show desire output
    Last edited by mohan.r1980; 01-16-2019 at 05:23 AM.
    Regards,
    MohanS


    "Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi

    You can simply say thanks by clicking "*Add Reputation" icon

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,980

    Re: please, detect the quantity of each group in the list

    You need to provide more detail in what you want, as well as some expected outcome - and how you got that.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,651

    Re: please, detect the quantity of each group in the list

    hello, moharn is for a 100/20 keno lottery,
    are drawn 20 numbers, on the question of the list, is this from the left of the planilia
    * was divided the 100 numbers into 25 groups of 4 numbers, the macro will identify the quantity
    * in each group by draw line, the macro or formula, has to look at each draw line
    * to see in the 25 groups, the amount, you can change the (x) by or 1 ok doubts?

  5. #5
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    714

    Re: please, detect the quantity of each group in the list

    i am not getting your points.
    In your attached excel show the exact look of ouput

  6. #6
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,651

    Re: please, detect the quantity of each group in the list

    MOHAN
    you have to identify the number of numbers in each group in the list on the left, think!

  7. #7
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: please, detect the quantity of each group in the list

    Please add some manually calculated results. Your explanation is not at all clear.
    Glenn



  8. #8
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,651

    Re: please, detect the quantity of each group in the list

    hello [COLOR="#FF0000"]Gle[/COLOR]nn was divided into 25 groups of 4 numbers, the macro or formula, will identicar the quantity in each group, zero is when it did not have a number drawn in the group
    * two or three markings, there are two or three numbers in this group, it is easy to

  9. #9
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: please, detect the quantity of each group in the list

    As I asked previously, please post a sheet with manually calculated expected results.

    You do not speak English as your mother tongue. I cannot understand your words.

  10. #10
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,651

    Re: please, detect the quantity of each group in the list

    Okay, Glenn but if you look at the first line has a value (x) in each group, I just did not do it until the end, but I can see that it is to detect the quantity of each group! is easy

  11. #11
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    24,317

    Re: please, detect the quantity of each group in the list

    A slight change in layout and output, using an array formula:

    =COUNT(IF($A7:$T7>0,IF(ISERROR(MATCH($A7:$T7,V$3:V$6,0)),"",$A7:$T7)))

    Array Formulae are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

    You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

    Don't type the curly brackets yourself - it won't work...
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    11-29-2014
    Location
    brasil
    MS-Off Ver
    excel 2014
    Posts
    1,651

    Re: please, detect the quantity of each group in the list

    ok,GLENN, corret, perfect, conglatulations, thank you!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. detect in each group with their suits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-02-2018, 10:17 PM
  2. detect in each group with their suits
    By jorel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2018, 05:08 PM
  3. Generate random group of words in a cell from a large group word list in column
    By faizzsheikh in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 07-26-2018, 10:16 AM
  4. Replies: 3
    Last Post: 05-22-2016, 06:30 AM
  5. [SOLVED] Counting total quantity for a group of variables.
    By Ekspulsio in forum Excel General
    Replies: 3
    Last Post: 06-08-2012, 04:02 AM
  6. How to detect name is appear in list.
    By Shermaine2010 in forum Excel General
    Replies: 8
    Last Post: 09-30-2011, 04:38 PM
  7. If quantity is 'this' and list choice is 'that' then ...
    By kfalconer in forum Excel General
    Replies: 6
    Last Post: 03-30-2010, 11:35 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1