Avatar of ADRIANA P
ADRIANA P
Flag for United States of America asked on

pairs count in 4n by 2wks

4n to add 2wks count

29224420.xlsb


1- Button PAIR  -- we do in BX BY BZ  -- we do PAIRS counts by 1 week


2-  now for every 2 weeks -- create an button call 2wksPAIRS--in CO1 CP1 CQ1


3-then count every 2 weeks   the PAIRS more than 3 times for every 2weeks
in columns  CO CP then CQ  



Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

Try this.
29224563.xlsb
ADRIANA P

ASKER
i just hit the 2Wks Pairs and get this

ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ADRIANA P

ASKER
can be adjusted to work  this way Best Expert !! Please whenever you can

example

1week  =  week A  =  1 week not 2 weeks

2 week  =  weeK B  = week A + week B = 2weeks

3 week = Week C = Week B + Week C = 2 weeks

4 Week = Week D = Week C + Week D = 2weeks

5 Week = Week E = Week D + Week E = 2Weeks

etc......






Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Martin Liss

Please repeat that using actual week numbers.
ADRIANA P

ASKER
here an sample week 42W2012 + 43W2012 shown in 43W2012


ADRIANA P

ASKER
here week 2W2012 + 3W2012 in 3W2012
29224563a.xlsb




Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Martin Liss

Is tis what you want? It counts the first week and then it counts every two weeks after that. In other words (like I asked you to show me using actual week numbers)
1W2012 shown in 1W2012
2W2012 + 3W2012 shown in 3W2012
4W2012 + 5W2012 shown in 5W2012
6W2012 + 7W2012 shown in 7W2012

¿Es esto lo que quieres? Cuenta la primera semana y luego cuenta cada dos semanas. En otras palabras (como te pedí que me mostraras usando números de semana reales)
1W2012 mostrado en 1W2012
2W2012 + 3W2012 mostrado en 3W2012
4W2012 + 5W2012 mostrado en 5W2012
6W2012 + 7W2012 mostrado en 7W2012
ADRIANA P

ASKER
 Best Expert!

Please  !!     need like this  :

1W2012 shown in 1W2012
1W2012 + 2W2012 shown in  2W2012 ( this way i have 2 weeks  in sequence)
2W2012 + 3W2012 shown in  3W2012
3W2012 + 4W2012 shown in  4W2012
4W2012 + 5W2012 shown in  5W2012
5W2012 + 6W2012 shown in  6W2012
6W2012 + 7W2012 shown in  7W2012
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ADRIANA P

ASKER
Much Better !!

Thanks Great Job !!

Best Expert !!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23