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

asked on

data in columns F G i J 2n

29262750a (1).xlsm


1- for the selector in F6  G6  I6   J6


When I press the Find 2 button, it lets me select the value that I am interested in from the line that is selected with the point selector in F6  G6  I6   J6

the output is shown for each sheet, that is, if I select the ORD or num point, the output appears in the ORD or NUM sheet, the same for the MID

I need to see in the output the columns itself that I select as a query

That is, if I select the value 52 columns F I need to see in the results the correspondence to the weeks of the column that makes the query with 52 next to it

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

I can tell that you used Google Translate and that's good:).  However "point selector" should be "option button".

What do want to have happen that isn't happening now?
¿Qué quieres que pase que no esté pasando ahora?
Avatar of ADRIANA P

ASKER

I need to see the key column in the output


User generated image


I'm looking at the code for the 'Find 2' button. I probably wrote it for you a long time ago, but it's poorly documented and very confusing. With the option button in column F selected, if I click the button and enter 31 I get results in Num worksheet but if I enter 92 it tells me that 92 is not found. Why is that?

Estoy mirando el código del botón 'Find 2'. Probablemente lo escribí para ti hace mucho tiempo, pero está mal documentado y es muy confuso. Con el botón de opción en la columna F seleccionado, si hago clic en el botón e ingreso 31, obtengo resultados en la hoja de trabajo Num, pero si ingreso 92 me dice que no se encuentra 92. ¿Porqué es eso?

well 92 is not an key if you use the find windows FIND ( contrl+F) excel but 31 is an key and have many keys


to me FIND 2  is working until now as needed  


but in the output sheet, I need to see the key when i query


the reason i need is because it let me call the key and 

the numbers that are similar or that contain the number that I entered, for example, if I enter 31, it gives me all the keys with 31 regardless of the decimal that it has and that helps me. because it calls all the keys that contain the number that I entered example 31


If I use the look up button it only gives me the numbers exactly the same in the decimal and although that is fine there are times when I need to choose the surroundings and not the exact number which the lookup button does not allow me



I think I understand what you want me to change in the current workbook, but since currently it doesn't allow you to find surrounding numbers and the code is poorly written, I'd like to completely rewrite the code for the button. If you are okay with that then please, in as much detail as possible, if the option button in column F is selected tell me what the code should do.

Creo que entiendo lo que quiere que cambie en el libro de trabajo actual, pero dado que actualmente no le permite encontrar los números circundantes y el código está mal escrito, me gustaría volver a escribir completamente el código del botón. Si está de acuerdo con eso, por favor, con tanto detalle como sea posible, si el botón de opción en la columna F está seleccionado, dígame qué debe hacer el código.

Basically, he is already doing what is necessary I just give him a two-digit number and he brings an output

which I need as a comment that includes the source column (key)

and puts the information by set in the corresponding sheet


You can ask me which columns I want to add that would help because I can choose ORD and NUM and the key column can be F in this case as an example

Where is the two digit number supposed to be found?
Also if we ignore where the output goes, how is Find 2 button different from the Lookup... button?

Además, si ignoramos a dónde va la salida, ¿en qué se diferencia el botón Find 2 del botón Lookup...?

the reason i need is because it let me call the key and 

the numbers that are similar or that contain the number that I entered, for example, if I enter 31, it gives me all the keys with 31 regardless of the decimal that it has and that helps me. because it calls all the keys that contain the number that I entered example 31


If I use the look up button it only gives me the numbers exactly the same in the decimal and although that is fine there are times when I need to choose the surroundings and not the exact number which the lookup button does not allow me


Where is the two digit number supposed to be found? 


as the selector is selected num column F  num mid column  G  ord column I  ord mid column J


the lookup button dont let me select 32  and call all the 32


it call specific numbers key

call all the 32 keys no matter 

What I want to explain is that the find2 button allows me to search for approximations because it calls all 32 and so I can choose an approximation from the output

In your picture you show decimal values in row 1. How did you do that?

that picture was made with out from SET with lookup button.jut to show the key columns in the output

Okay then I need you to click the Find 2 button and then insert any new column(s) that you want and show me a picture of the results. Better yet, attach the workbook that has the manually modified results.

Bien, entonces necesito que hagas clic en el botón Buscar 2 y luego insertes las columnas nuevas que quieras y me muestres una imagen de los resultados. Mejor aún, adjunte el libro de trabajo que tiene los resultados modificados manualmente.
What columns did you add?

C H M R  W  in num sheet are added from query 33 with find button

I see the new data in those columns but I don't know why you refer to the ORD sheet. Did you mean the ORD column?

Veo los nuevos datos en esas columnas, pero no sé por qué se refiere a la hoja ORD. ¿Quiso decir la columna ORD?

I meant to say sheet NUM but I was wrong and I said ORD

So what column on the DTA2N sheet did you query?

column F

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

is a great job   best expert


can get 3 weeks before and 10 after in the output sheet. Please

Please ask a new question.

ok