range count show in 1 set 4N w P

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

as  show here

a1.PNG

this is an range count


 



here the file
29084873--3-_4N_pair_button-_workin.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
What does the second picture have to do with the problem?
1
ADRIANA PACCOUNTING 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
Martin LissOlder 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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Martin LissOlder 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
ADRIANA PACCOUNTING 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
ADRIANA PACCOUNTING 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
ADRIANA PACCOUNTING 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
Martin LissOlder 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
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
111ccccc.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
1bb.PNG

in the ID: 42475712
you are in the correct way Martin
0
Martin LissOlder than dirtCommented:
You didn't answer my question.

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
Martin LissOlder than dirtCommented:
Wait. Let try something first.
1
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

You didn't answer my question.

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
Martin LissOlder than dirtCommented:
OK I understand now. I've got something else to do now but I'll be back later.
1
Martin LissOlder than dirtCommented:
1
ADRIANA PACCOUNTING 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

wwww1111.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
can be in another question for
0
Martin LissOlder than dirtCommented:
Already done.
29085099a.xlsm
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Working as needed  

Great JOb !

Best Expert Ever !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.