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:

And in Excel you paste, and copy the number column

And you paste/transpose and copy the results again

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

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

There you have your filter.

Now you have two options. Maybe there are more.

Thanks again Kerry!