# range count show in 1 set 4N w P

button to provide the range  for CE (CF the count)

as  show here

this is an range count

here the file
29084873--3-_4N_pair_button-_workin.xlsm
###### Who is Participating?

Older than dirtCommented:
29085099a.xlsm
1

Older than dirtCommented:
What does the second picture have to do with the problem?
1

ACCOUNTING ASSISTANTAuthor Commented:
Martin

try to show that the ranges count comes fron the pair count first

but can be delete if not needed to explain
0

Older than dirtCommented:
It looks like the source for columns CE and CF is the same as the source for BX and BY. You show 2-digit numbers in both BX and CE, but the numbers are different. Why?
1

Older than dirtCommented:
You also show "10" in cell CE1545. That seems to violate the rule that a zero should be before any odd number, so what isn't it "01"?
1

ACCOUNTING ASSISTANTAuthor Commented:
Martin

It looks like the source for columns CE and CF is the sane as the source for BX and BY

Good Point is almost the same
Yes because the range comes out of the pair count (
lets say this way
1- first pair count
then
2- is the range  ( range comes fron the pair, example  12 is range 10 ,  23 is  20 range  ect....)

then

3- column CE is the range  as is belongs  from the pair

34 is 30    than 30 is the range

4- then  CF columns  is the count for each range  ( the count make them be in orden )
0

ACCOUNTING ASSISTANTAuthor Commented:
MArtin

You show 2-digit numbers in both BX and CE, but the numbers are different. Why?

The range is fron the total 1 set (13 rows)
not just for the more higher

as we take the  13 rows (  1 set ) then  the we put in the CE and CF  the total  count of range for that set
0

ACCOUNTING ASSISTANTAuthor Commented:
Martin

You also show "10" in cell CE1545. That seems to violate the rule that a zero should be before any odd number, so what isn't it "01

No rule is broken at this point
because

the set is in order  as the rule  ( column BF)

from that order we analyze the PAIR AND TRI
(remember The RANGE count belongs from The TOTAL PAIR COUNT )

other way

column BF  is the source
1-then  we take the higher PAIR  from there (THAT THE PAIR )
2- then also we count the total PAIR
3-from the TOTAL PAIR WE TAKE THE RANGE COUNT
0

Older than dirtCommented:
So if I understand correctly, the "10" in cell CE1545 represents a range of numbers from 10 to 19. I also assume that the "8" in CF1545 is a count of some values for that week in column BF. If so then using the actual numbers in CE please explain why each cell caused the count to be increased. What I'm looking for from you is something like

BF1539 does not add to the count
BF1540 does add to the count because...

Entonces, si entiendo correctamente, el "10" en la celda CE1545 representa un rango de números del 10 al 19. También asumo que el "8" en CF1545 es un recuento de algunos valores para esa semana en la columna BF. Si es así, entonces usando los números reales en CE, explique por qué cada celda hizo que se aumentara el conteo. Lo que estoy buscando de ti es algo así como

BF1539 no se agrega al conteo
BF1540 se agrega al recuento porque ...
0

ACCOUNTING ASSISTANTAuthor Commented:
0

ACCOUNTING ASSISTANTAuthor Commented:

in the ID: 42475712
you are in the correct way Martin
0

Older than dirtCommented:

Using the actual numbers in CE please explain why each cell caused the count to be increased. What I'm looking for from you is something like

BF1539 does not add to the count
BF1540 does add to the count because...
1

Older than dirtCommented:
Wait. Let try something first.
1

ACCOUNTING ASSISTANTAuthor Commented:
Martin

Using the actual numbers in CE please explain why each cell caused the count to be increased. What I'm looking for from you is something like

BF1539 does not add to the count
BF1540 does add to the count because...

in this situation all have to be count

none one is left out
because we need  THE TOTAL  NOT  ONLY THE HIGHER
0

Older than dirtCommented:
OK I understand now. I've got something else to do now but I'll be back later.
1

Older than dirtCommented:
1

ACCOUNTING ASSISTANTAuthor Commented:
MArtin is an great JOB

Well Done !

what need now is show the first 3 ranges together
in column CG

like show here

0

ACCOUNTING ASSISTANTAuthor Commented:
can be in another question for
0

ACCOUNTING ASSISTANTAuthor Commented:
Working as needed

Great JOb !

Best Expert Ever !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.