create lookup for PAIRS to byset 4n

Just to avoid confusion if other experts look at this question, when you say "subform" you really should instead say "userform".

Thanks Best Expert !!

my correction you are rigth is an  userform.

I assume that when you click the PAIRS SETS button you want the userform to show the values from column CB. What do columns AZ , AU , AV , AW , AX , BF, BX , BZ , BC have to do with that?

Supongo que cuando hace clic en el botón CONJUNTOS DE PARES, desea que el formulario de usuario muestre los valores de la columna CB. ¿Qué tienen que ver las columnas AZ, AU, AV, AW, AX, BF, BX, BZ, BC con eso?

columns AZ , AU , AV , AW , AX , BF, BX , BZ , BC have to do with that?

Ideally, I would be able to select the columns that I want to analyze at the moment, but since I cannot do so
I am putting the columns that I need to analyze

These columns are important because I need to see what happens when they all coincide with the same index in this case the index is the number that is in the CB column

Although you didn't say so (and you really should) it looks like what you are showing in the SETS sheet are the nine columns AZ, AU, AV, AW, AX, BF, BX, BZ and BC and I have some questions about that worksheet.

1. Do you want to show the date as we do in column 'A' of the RNUM sheet?
2. Are there times when you might not want to show all nine columns?
3. Are there times when you might want to show columns that are not included in the nine columns you referred to?

Aunque no lo dijo (y realmente debería), parece que lo que está mostrando en la hoja SETS son las nueve columnas AZ, AU, AV, AW, AX, BF, BX, BZ y BC y tengo algunas preguntas sobre esa hoja de trabajo.

1. ¿Quiere mostrar la fecha como lo hacemos en la columna 'A' de la hoja RNUM?
2. ¿Hay ocasiones en las que es posible que no desee mostrar las nueve columnas?
3. ¿Hay ocasiones en las que podría querer mostrar columnas que no están incluidas en las nueve columnas a las que se refirió?

1. Do you want to show the date as we do in column 'A' of the RNUM sheet?
   
   yes!!
   
   
2. Are there times when you might not want to show all nine columns?
   yes !
   
   
3. Are there times when you might want to show columns that are not included in the nine columns you referred to?
   
   yes !

For #3 I need a list of all the columns you might ever want to see on the SETS sheet.

Para el n. ° 3 necesito una lista de todas las columnas que quizás desee ver en la hoja SETS.

columns :

B
AU
AV
AW
AX
AZ
BF
BP
BX
BZ
CB
CC
CG
CI
CJ
CL
DF
DL
DT
EA
EN
EO
EQ
ES
EV
EX
EY
FA
FC
FH
FO
GJ
GL
GN
GP

I just noticed that in the workbook you attached that 14W2012 is missing the data for Friday AM. If you can attach a workbook that has that day's data then I can copy it.

It's worse than that. To be safe I'll need to copy all the data.

i get that  worked  just a minute

14W2012 is missing the data for Friday for some reason like Holy Friday not  avaliable 

here the dates fixed
4N_toadd_dt.xlsx

I haven't yet corrected the data and I also haven't yet added the counts and some other fancy things to the top of the SETS form, but click the new PAIRS SETS button and let me know if you are happy with what I've done so far.

Todavía no he corregido los datos y tampoco he agregado los recuentos y algunas otras cosas elegantes en la parte superior del formulario SETS, pero haga clic en el nuevo botón PAIRS SETS y avíseme si está satisfecho con lo que yo ' lo he hecho hasta ahora.
29224260.xlsb

Looking Good !

You are the best !!!
no body will do better job

Great Job

Best Expert !

working as expected

Need make un adjustment

in the SETs sheet

I need the result to be 2 sets before the index set

and 10 down the index set


that is, 2 before and 10 after

Please!!!

Gave you filled in any missing data? If so I need the updated workbook.

Everything is working fine !!
but I need there to be 2 sets before the index set and 10 sets after

2 upper and 10 donw

I understand that. I was referring to the missing data that I pointed out and I was asking if you made any changes to the missing data, and if you did that then I would need a copy of the updated workbook.

Entiendo que. Me refería a los datos faltantes que señalé y le estaba preguntando si hizo algún cambio en los datos faltantes, y si lo hizo, necesitaría una copia del libro de trabajo actualizado.

29224260a - Copy.xlsb

here is !!

Sheet1 like row 14 columns M, N and O

in this row 14 and columns M, N, O there are no data for that day

in this row 14 and columns M, N, O there are no data for that day 

I mean that it is not your error, nor is it my error that it is a holiday (Good Friday) and there is no data for that day ...

I checked if there was data for that day and there can be no or it will be a holiday

Okay, I believe there was data there previously but I'm not 100% positive. But what about the dates in this picture I attached above?

Calling column AZ i get an wrong output

Okay, I believe there was data there previously but I'm not 100% positive. But what about the dates in this picture I attached above? 

Those dates the data is fine, only the dates had to be restored but it is already corrected

If you aren't worried about the "missing" data then I'm not, but it's strange that in all the time I've been working with you that I never noticed before.

Please open a new question for AZ and I'll try to fix it.

Si no está preocupado por los datos "faltantes", entonces no lo estoy, pero es extraño que en todo el tiempo que he estado trabajando con usted nunca lo haya notado antes.

Abra una nueva pregunta para AZ e intentaré solucionarlo.

ok ....