Link to home
Create AccountLog in
Avatar of ADRIANA P
ADRIANA PFlag for United States of America

asked on

Select more than one PAIR in 2n column E

Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Okay here it is. I've changed the userform in this workbook so that it looks like this. If you need the textbox pointed to by the arrow, please help me understand why.

De acuerdo, aquí está. He cambiado la forma de usuario en este libro de trabajo para que se vea así. Si necesita el cuadro de texto señalado por la flecha, ayúdeme a comprender por qué.
User generated image
Avatar of ADRIANA P

ASKER

Martin

in some situations moving faster  the textbox  help me a lot
Okay I'll leave it but I think the new checkboxes are easier to use. Is the rest if the workbook okay?

Está bien, lo dejaré, pero creo que las nuevas casillas de verificación son más fáciles de usar. ¿Es el resto si el libro de trabajo está bien?
Yes !!


well the relative  button is not working

but  should be chechk in other question
well the relative  button is not working
Please don't make me have to guess what isn't working; tell me.

Por favor, no me hagas adivinar lo que no funciona; Dime.
Martin

the realtive button
I know you mean the relative button. What I don't know is what you mean when you say it isn't working. All these things could be what you mean when you say it isn't working:
  • When I press the button Excel crashes.
  • When I press the button nothing happens.
  • When I press the button I get the wrong results.

Those are the things that I need to know. When you don't give me enough information I have to guess at what's wrong.

Sé que te refieres al botón relativo. Lo que no sé es a qué te refieres cuando dices que no está funcionando. Todas estas cosas podrían ser lo que quieres decir cuando dices que no funciona:
  • Cuando presiono el botón Excel se bloquea.
  • Cuando presiono el botón no pasa nada.
  • Cuando presiono el botón obtengo los resultados incorrectos.

Esas son las cosas que necesito saber. Cuando no me das suficiente información, tengo que adivinar lo que está mal.
Martin   the relative button


When I press the button nothing happens.


Cuando presiono el botón no pasa nada
Okay here is the problem. The workbook that you originally posted was not set up for 2N. What I mean by that is that there should not be 'Left 3' and 'Right 3' sections as shown in the picture. Hopefully you can find a previous 2N workbook that only has one section under the Relative button. If you can find it then attach it here and I'll make the same changes that I made in 29172063.xlsm.

De acuerdo, aquí está el problema. El libro de trabajo que publicó originalmente no se configuró para 2N. Lo que quiero decir con eso es que no debería haber secciones 'Left 3' y 'Right 3' como se muestra en la imagen. Espero que pueda encontrar un libro de trabajo 2N anterior que solo tenga una sección debajo del botón Relativo. Si puede encontrarlo, adjúntelo aquí y haré los mismos cambios que hice en 29172063.xlsm.
User generated image
Martin

can we do the pairs in column E

then closed the question
 
it will take me some times  to find other 2N workbook

rigth now is not the priority for me
No I don't want to do that because as I said, the workbook that you originally posted was not set up for 2N and if I make more changes to it I'd just have to redo them for a proper 2N workbook.

No, no quiero hacer eso porque, como dije, el libro de trabajo que publicó originalmente no estaba configurado para 2N y si hago más cambios, solo tendría que rehacerlo para un libro de trabajo 2N adecuado.
I've found a workbook of yours (29152402.xlsm) where we did "relative" for 2N, but in that workbook "relative" looks like the picture below which is very different than the "relative" in the workbook you attached for this question so I don't know what you want to do.

Encontré un libro de trabajo suyo (29152402.xlsm) donde hicimos "relative" para 2N, pero en ese libro de trabajo "relative" se parece a la imagen de abajo, que es muy diferente al "relative" en el libro que adjuntó para esto. pregunta, así que no sé qué quieres hacer.

User generated image
Martin

ok we can use the last one you find will be ok to me
What would you like me to do in that workbook?
Martin

can you send me the last book?
What would you like me to do in that workbook?

is need do the column E

to find multiple pairs
Let me show you a trick. (At the end of the video I press Return.)
2020-02-10_07-42-13.mp4
Why did you choose this post of yours as the solution?
Also
is need do the column E

to find multiple pairs
Don't you mean column 'A'?

In case you can't get my trick to work, here's the workbook.
29152402.xlsm
Martin

i was posting an comment

for some reason it select the solution  was not me  or my intention
I've asked a moderator to undo that selection of the post as a "solution".
Martin

ok i see you point now

let that as is

please

keep the  working on file 2N_to_find_pair.xlsm
to column E to work with multiple pairs

because it will be other work
I've asked a moderator to undo that selection of the post as a "solution".

Thnaks !!!
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
I already did that in the 29172063.xlsm file I attached earlier. That workbook has mysteriously disappeared however so I'm attaching it again.

I never see it !! until now

that why i keep asking for  work on it
Im trying to give the points ! !
I never see it !! until now
Okay but what did you mean when you said the relative button isn't working in this post?
Okay but what did you mean when you said the relative button isn't working in this post?

when i hit the button RELATIVE  it don't show the  data as needed

but i saw this in file 4N and 3N

this 2N file look is working

than i understand your confution
but i will need work that some times foward rigth now need work with  tri in file 4N  
i will open an new question for