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
|