Start Free Trial

asked on

2N bySET 0DIGIT

show data from column A by set (13 ROWS)
when select 0digit from column X

User generated image

call the new sheet "BySET"
29122869b--1-_2N_to_BYSET.xlsm

Try this.
29122897.xlsm

ASKER

Martin

Great Job

but the selctor in this case is any number in column X

Some numbers in column 'X' appear more than once. For example 85 appears in both weeks 9W2012 and 14W2013. What do you want to show in that case?

ASKER

Martin that the idea it will pick the repeats

Try this.
29122897a.xlsm

ASKER

Martin

great but

need see column A data

Should I put it in column 'A' of the "By set' sheet or under the 0 number in column 'D' of that sheet.

ASKER

Martin

like this should be

User generated image

Once more.
29122869b.xlsm

ASKER

Martin

please verify is not working

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

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

Start Free Trial

ASKER

Exactly right! !!

ASKER

Best Expert !

ASKER

Martin

some issues are

some issues are

Are you trying to say "There are some problems". If so please tell me what they are.

ASKER

Martin

in the By SET sheet it repeat the data

i mean the ocurrences are 4 for example

then shown all 2 times (8times )

Are you talking about AM and PM?

ASKER

Are you talking about AM and PM? no

No

the ocurrences by columns

One question can be show the total ocurrebces

lets say 1 ocurrence of 4 ,, then 2 ocurrences of 4 ect..

ASKER

i mean you have the selected digit then the ocurrence

example

5 ocurrence 1 of 9

OK
29122897c.xlsm

ASKER

Getting Better and better with each improve

Great Expert !