# pairs count in 4n by 2wks

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

Last Comment

8/22/2022 - Mon
Martin Liss

Try this.
29224563.xlsb

i just hit the 2Wks Pairs and get this

Martin Liss

Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
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.

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.

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

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)
2W2012 + 3W2012 mostrado en 3W2012
4W2012 + 5W2012 mostrado en 5W2012
6W2012 + 7W2012 mostrado en 7W2012

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