View Single Post
 
Old 06-29-2017, 08:39 AM
ertuu85 ertuu85 is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2017
Posts: 1
ertuu85 is on a distinguished road
Default Filtering question

I generate an excel spreadsheet through powershell that grabs a file path and lists its permission in a fashion like

Path is always just cell A
User is always cell B
Access is always cell C

Col A B C
c:\path\path2\this\that\ect (This is all in cell A)
user1 FullControl
user2 Read&Execute
c:\path2\path3\this\that\whatever
user3 FullControl
user6 Ready&Execute
c:\path3\path3\this\that\whatever
user4 Modify
user5 Modify
user6 Modify


Is there a way to filter this by column B or C, and it return it's 'path' row? say I filter column B for user6 it would return something like:
Col A B C
c:\path2\path3\this\that\whatever
user6 Ready&Execute
c:\path3\path3\this\that\whatever
user6 Modify
Reply With Quote