Filtering question

[ertuu85]

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

[gebobs]

Is the path repeated for each record. For example the first data above...

c:\path\path2\this\that\ect user1 FullControl
c:\path\path2\this\that\ect user2 Read&Execute

If so, filtering is easy. If not, I would see if there is a way for your generator to do that. Otherwise, you could write a macro or have some formulas do that.