Tip #39 | Pipe Filter with Excel | Alternative


I just looked at the video by Kerry Rosvold on how to make a pipe filter in excel. It’s awesome. You can watch it here.

Now, I have an alternative way that I have been using for the last many many years and I don’t understand why I never shared it.

Blogging it now kinda make me a smart-ass. Maybe I am that. I apologize. 😉

So this is how I do it.

You copy a few lines to excel like this:

2014-12-04_20-25-50

And in Excel you paste, and copy the number column

2014-12-04_20-27-37

And you paste/transpose and copy the results again

2014-12-04_20-29-07

Then you open a notepad, paste the rows and copy the tab character

2014-12-04_20-30-17

Then you select find/replace, paste the tab character and replace with the pipe sign

2014-12-04_20-31-31

There you have your filter.

Now you have two options. Maybe there are more.

Thanks again Kerry!

Advertisements
This entry was posted in Tips and Tricks and tagged , , . Bookmark the permalink.

7 Responses to Tip #39 | Pipe Filter with Excel | Alternative

  1. Pingback: Tip #39 | Pipe Filter with Excel | Alternative - Mark Brummel - Author of Microsoft Dynamics NAV 2009 Application Design

  2. Pingback: Pipe Filter with Excel Alternative! | Dynamics NAV Financials

  3. Pingback: Pipe Filter with Excel Alternative! - Microsoft Dynamics NAV Community

  4. Pingback: Pipe Filter with Excel | Alternative 2 - Mohana's Dynamics NAV Blog - Dynamics User Group

  5. Pingback: Pipe Filter with Excel | Alternative 2 - Microsoft Dynamics NAV Community

  6. Pingback: Tip #2 - Pipe Filter with Excel | Alternative 3. - Microsoft Dynamics NAV Community

  7. Pingback: Selection Filter to Clipboard | Gunnar's Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s