Excel RAW Filtering

[vonmunchy]

I have attached a copy of my workbook. Each raw contains a lot of details. How can i have just the ID No, Gender and DOB in a new sheet.

[Pete_UK]

First of all, you need to align those dates of birth and genders into the same column. I did this manually by shifting cell across (inserting or deleting cells). Then you can just do a simple Copy/Paste to Sheet3.

Hope this helps.

Pete

[TMS]

Sheet3 A2:

Please Login or Register  to view this content.

Sheet3 B2:

Please Login or Register  to view this content.

Sheet3 C2:

Please Login or Register  to view this content.

formatted as a date



Copy all the formulae down for as many rows as you have in the raw data sheet.


Regards, TMS

[TMS]

See attached updated example.


@Pete: he doesn't *have* to restructure his data although it would make life easier.


Regards, TMS