Isolating Information from Specific Columns in an Excel Spreadsheet?

Hi Everyone,

Hope this finds you well.I hope that someone can help me out here.

I am new to Excel and have been given a large database of contact details. In columns A,B,C are lists of individuals names and contact details. Then in columns D,E,F are a series columns which 'define the identity' of that person (e.g. One column headed 'service users' with an 'x' in the column next to an individual's name if they are a service user, one column headed 'workforce' with an 'x' in the column next to the name if that person is a member of the workforce)

What I am looking to do is find a way of 'isolating' the information in the database in terms of the columns which define the identity of each person.

e.g. So for example I want to just see the contact details of the service users, I do not have to trawl through and check each name with an 'x' next to it in that column.

I hope this makes sense. I'd really appreciate if anyone can steer me in the right direction. I am sure that Excel is capable of this task but I have no idea how to go about it. I would really appreciate any help that someone more experienced than myself can give here.

Many thanks!

Matt

Hello actiontrack, welcome to the forum can you please upload a sample workbook with sensitive data removed with the results you are looking for ??

Hi Hemesh, thank you for your quick response really appreciate it. Yes here is an uploaded version of the database with all sensitive details removed (Columns B-E on my version are full of details, of course). The 'identity' columns with x's in are F-J

Any step by step help you can offer is gratefully received! As I am new to excel.

Many thanks

To make things clearer:

I am looking for any way at all in which I can click something to allow me to see only the listed results from one type of person e.g. if I want to see only details from the members of the workforce (ie. those with an 'x' in the workforce column) then I can do so.

I hope this is possible!

why you dont go with filtering this data base ?

How do I go about filtering this database?

Hello actiontrack, you can use two option one is pivot table and other is sorting option you can once go through the attached file and choose what suits your requirement. I have added links in the file! Hope this helps

if your query is solved and answer satisfies you click " * " icon in the left hand side and mark thread as solved.