please, detect the quantity of each group in the list
https://www.excelforum.com/attachmen...1&d=1547629654
please, detect the quantity of each group in the list
https://www.excelforum.com/attachmen...1&d=1547629654
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
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
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?
i am not getting your points.
In your attached excel show the exact look of ouput
MOHAN
you have to identify the number of numbers in each group in the list on the left, think!
Please add some manually calculated results. Your explanation is not at all clear.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
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
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.
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
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...
ok,GLENN, corret, perfect, conglatulations, thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks