Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-29-2017, 08:39 AM
ertuu85 ertuu85 is offline Filtering question Windows 10 Filtering question Office 2016
Novice
Filtering question
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering data teza2k06 Excel 1 01-24-2014 12:53 PM
Filtering Data TotalONE Excel 0 12-26-2013 07:01 PM
Filtering Tasks timvb85 Outlook 0 11-15-2010 08:30 PM
Filtering out CC's arzsupra Outlook 0 03-11-2008 05:55 PM
contacts filtering bubba622 Outlook 0 05-01-2006 03:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft