# please, detect the quantity of each group in the list

1. ## 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

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

where is the list?
exlplain clearly
show desire output

3. ## 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.

4. ## 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. ## 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. ## 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!

8. ## 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. ## 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. ## 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. ## 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...

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

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

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

#### 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