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

3N R to be ADjusted MID

3N R wADJTFULL now MID week

29217107.xlsm

 to be ADJUSTED


this file si not counting the ranges as needed in MID WEEK

1- example
ABC  = AB BC AC


as we did here
but now for MID WEEK

https://www.experts-exchange.com/questions/29217107/3N-R-to-be-ADjusted.html?anchor=a43295675&notificationFollowed=271524493#a43295675

VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
Martin Liss

this file si not counting the ranges as needed in MID WEEK
Are you sure? I ask because it uses the same code as Full Week. If you still think it's wrong then please tell me a week that wrong and what it should be.

¿Está seguro? Lo pregunto porque usa el mismo código que Full Week. Si todavía cree que está mal, por favor dígame una semana que está mal y qué debería ser.
ADRIANA P

ASKER
Full week is working great

but what in need is the MID week pairs button 
Martin Liss

but what in need is the MID week pairs button
The MID week pairs button is right next to the Full weeks pair button.
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
ADRIANA P

ASKER
is not count all pairs as do FULL weeks pairs
Martin Liss

If you still think it's wrong then please tell me a week that wrong and what it should be.
ADRIANA P

ASKER

⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

it don't count 70
Isn't mid-week Monday to Wednesday? If so there's only one 70 range and we don't list them unless there are two or more.

¿No es entre semana de lunes a miércoles? Si es así, solo hay un rango de 70 y no los enumeramos a menos que haya dos o más.
ADRIANA P

ASKER
When i talk about TOP PAirs  it applies

but we are counting all the  pairs  in Range

Is not the Same as TOP PAIRs as Range 


ADRIANA P

ASKER
But i see you remembers the Rules

in this case for Range we need  count each pair
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Martin Liss

in this case for Range we need  count each pair
For just mid week or for mid week and full week?
ADRIANA P

ASKER
i need count each pair in Full and Mid week for  RANGE
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ADRIANA P

ASKER
Great JoB !! Best Expert !
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.