detect and add the quantities of letters in their groups

**jorel** · 02-26-2019, 07:29 AM

detect and add the quantities of letters in their groups
https://www.excelforum.com/attachmen...1&d=1551180540

**Andy Pope** · 02-26-2019, 08:45 AM

Does it need to be VBA?

AW6: =COUNTIFS($I$4:$AU$4,AW$4,$I6:$AU6,"X")

**jorel** · 02-26-2019, 08:49 AM

Does it need to be VBA? YES!please

**Andy Pope** · 02-26-2019, 09:02 AM

one of many ways to do it

Please Login or Register  to view this content.

**jorel** · 02-26-2019, 09:11 AM

I put it in the worksheet, but it is not running! can you see why it is not performing?

**Andy Pope** · 02-26-2019, 10:27 AM

Why did you put the code in the worksheet module rather than a standard module?

What error did you get?

Post example of what you have done

**jorel** · 02-26-2019, 02:59 PM

I put the macro in visual basic (modulo) gave the command execute, and nothing happens

**Andy Pope** · 02-27-2019, 04:29 AM

As you don't want to show me yours I will show you mine.

Run the macro X to populate cells.

**jorel** · 02-27-2019, 07:05 AM

hello Andy has something strange in the macro, I did the correct procedures
* the macro is not happening at all, it's not running, it's not doing anything, please !!

**Andy Pope** · 02-28-2019, 04:50 AM

Did you enable macros?

Try clearing the output cells before running the code so you can see the new output.

**jorel** · 02-28-2019, 06:24 AM

hello, ANDY POPE! I cleaned the cells, I did the procedures, but this one is running, can you do it on the planilia sent in the post? please

**Andy Pope** · 02-28-2019, 09:20 AM

I did use the file you posted. I simply copied the code into it and saved with the thread number and .xlsm file format

**jorel** · 02-28-2019, 10:31 AM

hello ANDY !!!maybe it's a misunderstanding
* the amcro has to do on all lines
* those two are just an example
and more every week I'll post new drawings
* the macro has to do all blank, it's not doing this

**Andy Pope** · 03-01-2019, 04:19 AM

Not so much a misunderstanding as you never mentioned the amount of 'X' would change.

Please Login or Register  to view this content.

**jorel** · 03-01-2019, 06:48 AM

the sum of the suit does not work,
* the macro does not work, put it on the sheet
no excel

**Andy Pope** · 03-01-2019, 09:11 AM

Sum and correction

Please Login or Register  to view this content.

**jorel** · 03-01-2019, 02:47 PM

HELLO ANDY=It didn't work because it classed the X's as data, not the actual results. They were not all filled in for all the draws, so it stopped after 2 rows.
I had to do formulas to put the Xs in.

**jorel** · 03-01-2019, 03:16 PM

andy , andy!!It did not work because it classified the X as data, not actual results. They were not all filled for all raffles, so they stopped after 2 lines.
* You have to make formulas to put the Xs. The macro depended on counting how many rows of X there were to work correctly you have to change to count how many RESULTS there are.

Nor does the SUM part see this

**Andy Pope** · 03-02-2019, 05:10 AM

Please Login or Register  to view this content.

**jorel** · 03-02-2019, 06:18 AM

huu andy, perfect, magnificent work,
* Correct, now it's working,
thank you!

detect and add the quantities of letters in their groups

LinkBack

Thread Tools

Rate This Thread

Display

detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Re: detect and add the quantities of letters in their groups

Thread Information

Users Browsing this Thread

Similar Threads

please, detect on each pair, * one of the 7 groups.

please detect the front double of the pick3 and see the amount of each groups.

[SOLVED] detect, the double, frontal or rear, according to the 6 letters .

detect, even / odd color and letters in matrix,

[SOLVED] please!!! locate the 18 patterns of the number quantities of the 3 letters.

Use Pivot Table and slicers if possible to detect combinations of quantities

[SOLVED] Using VBA to detect separate groups of rows.

Bookmarks

Bookmarks

Posting Permissions