4N to selector 3n data

This will take a while.

:)

What should happen if an ORD like 8879 (where there are not hits) is in the week?

Martin in this file we  are working with 0 as base

8879 have not 0 to follow

Currently if you click 'Count Hits' and enter 8879 you get this.

Is that a mistake? In other words does the value that you look for have to contain a 'o'?

well no i  would like to have the DD  too

but we have to put the PAIRS A TRI to work  they are not showing

because they only show up  with 0

I don't understand your answer so let me ask the question in a different way. If we are looking for the counts in week 2W2012 should anything show up on the new sheet for 8879?

No entiendo su respuesta así que permítame hacer la pregunta de una manera diferente. Si estamos buscando los recuentos en la semana 2W2012, ¿debería aparecer algo en la nueva hoja para 8879?

Yes!

In your first picture you show the results of 'Count Hits' after searching all the 3n data for ORD value 6055 and you show the highest 3n count as being selected. In your second picture you show the selected data in column 'C' of the 'Selector 3n' sheet. Note however that the 015 data is based on all the data in the workbook rather than just one week so wouldn't the results be the same no matter what week we searched for?

En su primera imagen, muestra los resultados de 'Count Hits' después de buscar en todos los datos 3n para el valor ORD 6055 y muestra la cuenta más alta de 3n como seleccionada. En la segunda imagen, muestra los datos seleccionados en la columna 'C' de la hoja 'Selector 3n'. Sin embargo, tenga en cuenta que los datos del 015 se basan en todos los datos del libro de trabajo en lugar de en solo una semana, por lo que, ¿no serían los mismos resultados sin importar la semana que buscamos?

Top Work

Top Expert !

Martin i get this

when i select  multiples dates

as shown

Great Job !!
Best Expert!