Filter By Selection

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Frequently I have trouble keeping track of which part I'm editing.

Keeping focused on the current part of interest would be much easier if there was a filter by selection feature, as shown below.

This is really the same functionality that "List All" gives us, but with significantly fewer steps.

To filter the current list using "List All"  we need to (Copy Cell > Select Find > Paste > Select List All)

more . . . 

For example: 

I would like to be able select a Part Number as shown above or any other cell. 

Press the Filter Icon button and viola ! 

For example, the list is has been filtered to display rows with P/N = SN74V263-6GGM

Same functionality as list all, but at a fraction of the work involved.

Using this Filter Feature,  I could quickly edit the record (part) with a higher degree of certainty that I'm editing the correct part.

Randy

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Randy Clemmons Members Profile Send Private Message Find Members Posts Add to Buddy List Advanced User Joined: 02 May 2012 Location: San Diego Status: Offline Points: 104	Post Options Post Reply Quote Randy Clemmons Report Post Thanks(0) Quote Reply Topic: Filter By Selection Posted: 01 Jul 2012 at 1:12pm
	Frequently I have trouble keeping track of which part I'm editing. Keeping focused on the current part of interest would be much easier if there was a filter by selection feature, as shown below. This is really the same functionality that "List All" gives us, but with significantly fewer steps. To filter the current list using "List All" we need to (Copy Cell > Select Find > Paste > Select List All) more . . . For example: I would like to be able select a Part Number as shown above or any other cell. Press the Filter Icon button and viola ! For example, the list is has been filtered to display rows with P/N = SN74V263-6GGM Same functionality as list all, but at a fraction of the work involved. Using this Filter Feature, I could quickly edit the record (part) with a higher degree of certainty that I'm editing the correct part. Randy



Tom H Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 05 Jan 2012 Location: San Diego, CA Status: Offline Points: 5719	Post Options Post Reply Quote Tom H Report Post Thanks(0) Quote Reply Posted: 01 Jul 2012 at 2:14pm
	So this is exactly like - Find > Find what: > SN74V263-6GGM List All The "List All" feature removes all rows that do not have SN74V263-6GGM in the entire library. There's also a "Look in:" feature to narrow the search filter to a single column to speed up the search. I think you want the same feature but only use 2 clicks. Click once in the cell and click on the icon and the program does this - Finds every occurance of that text Only search in the column that the text is in Eliminate every row that does not contain identical text Then the "Show All" icon would return the entire list.

Randy Clemmons Members Profile Send Private Message Find Members Posts Add to Buddy List Advanced User Joined: 02 May 2012 Location: San Diego Status: Offline Points: 104	Post Options Post Reply Quote Randy Clemmons Report Post Thanks(0) Quote Reply Posted: 01 Jul 2012 at 2:37pm
	Correct Tom, "That's what I'm talking about"