Extract or filter Data

[Cathrine Paul]

I have a large downloaded drilled down data.
A column contains its group numbers.its a raw format.
A column includes unique main group numbers with its sub group numbers.
its downloaded data from another application. so its contain unwanted numbers also.
For ex: group numbers stared with 045/001 instead of 001. but in my result only i need numbers as 001 ( without 045/) and its sub group also the same.
A column contains unwanted spaces also.
B and C columns contains its related data.

I want to filter this data with what are the main numbers i entered in D column.

For Ex: I have 99 main groups numbers and its sub group numbers
main group like this 001,002,... 099. (3 Digits) and its sub group 001001001,001001003 like this (9 digits ). (including 045/).

if i enter values in D column with 001,002,007,010,099. the result must be 001 and its sub,002 and its sub, 007 and its sub,010 and its sub,099 and its sub.
For more details pls refer the attached file

Pls help me.. thanks in advance.

[Richard Buttrey]

I'd add a couple of helper columns and use a Pivot table with a Slicer to select the Main Groups

See attached

[José Augusto]

Hi

Add a new column with the group number well formatted
To do that, use the following formula in column D from D2 and copy down

Please Login or Register  to view this content.

The label of this new column must be the label of the filter column
Use Advanced filter assistant (under Data tab) to get the desired result

See the file to clarify

[Cathrine Paul]

Thank you...
Its very helpful..

[Cathrine Paul]

Thank you so much for the reply.
could you please make a macro code for Update advanced filter result automatically on second sheet.?please

[José Augusto]

Hi Cathrine

You don't need that.

To get what you want just start the process on the target sheet (sheet2 if data is in sheet1).