asked on

Select more than one PAIR in 3n column E

select the pairs in column E

button WK SETS do with one pair
but need do with more than one pair at the time

(can be more than one pairs, as needed )

then show in an sheet call "E_PAIRS"

as 13 sets rows with ORD 2 before and then after

will need add SELECTOR too after the selction

3N_to_find_pair.xlsm

Martin Liss

Three questions:
1) Currently you can already select more than one pair. For this discussion, let's assume you pick 25 and 89. When you do that, 'E SETS' will show all the sets that contain either 25 and 89. Do you want me to change that so 'E SETS' only shows sets that contain both 25 and 89?
2) If I do that you will you ever want to look for either 25 and 89?
3) I can put the results in the existing 'E SETS' sheet. Why do you want a new 'E PAIRS' sheet?

Tres preguntas:
1) Actualmente ya puede seleccionar más de un par. Para esta discusión, supongamos que elige 25 y 89. Cuando haga eso, 'E SETS' mostrará todos los conjuntos que contienen o 25 y 89. ¿Quiere que cambie eso? 'E SETS 'solo muestra conjuntos que contienen tanto 25 como 89?
2) Si hago eso, ¿alguna vez querrás buscar ya sea 25 y 89?
3) Puedo poner los resultados en la hoja existente 'E SETS'. ¿Por qué quieres una nueva hoja 'E PAIRS'?

ADRIANA P

ASKER

Martin

i will need select sometimes more than 2 sets of pairs at same time

may be up to 5 or 6 pairs at time

if you can just adjust to work like that

will be not problem to me keep the same sheet output

ADRIANA P

ASKER

Martin

one details

i need the selection be tha same pairs only

for example

25 89 only need an output with the selected pairs not all the 25 and all 89 please!!

Martin Liss

Just to verify. You NEVER want to look for 25 OR 89. Correct?

Solo para verificar. NUNCA quieres buscar 25 O 89. ¿Correcto?

ADRIANA P

ASKER

Martin

yes it can be

what i mean is for example

suppose i need query for 25 and 89

then i will need the output with the 25 and 89 only

i will not need all the 25 and 89 columns

ADRIANA P

ASKER

i mean when i look for 25 and 89

is in the same week (13 rows set)

then show all the weeks with the 25 and 89 in the same week

ASKER CERTIFIED SOLUTION

Martin Liss

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ADRIANA P

ASKER

Great Job Best Expert !

Martin how many pairs i can look for at same time ?