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!