Hello everybody
I have a table containing rows with initials for employees. I want to filter this into 2 categories, say Developers and Business analysts.
To illustrate this:
Table 1:
KBC
PVR
ADF
MKB
AAC
LDR
etc.....
Say that KBC and AAC are Business analysts and PVR, ADF and LDR are developers. Is it possible to make 2 categories to filter between? Either show all Business analysts or all developers? BTW there is data specific to the initials in column B through I.
Hope you can help
Last edited by Aagaard806; 01-17-2018 at 03:56 PM.
Use another column for those categories, then you could filter directly on that column.
Hope this helps.
Pete
Please be more specific. If you're thinking of Advanced filtering then it wont give the user the possibility to filter the view between 2 categories?
If your names are in column A, then use column B to record either Analyst or Developer against each name. Then you can filter column B to see each group.
Is that specific enough?
Pete
Column B through I all contain data specific to the initials in Column A, and that is why i need to be able to filterso that it's possible to get an overview for the Business Analysts and for the developers
Since it has been a few days since the last response I would suggest that you upload a desensitized sample of your data. To upload a sample click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks