Monday, December 15, 2014

Tip #2 - Pipe Filter with Excel | Alternative 3.

Hi all,

I just looked at the video by Kerry Rosvold , an article from Mark Brummel & an article from Mohana on how to make a pipe filter in excel.

Link To Kerry Rosvold Video.

Link To Kerry Mark Brummel Article.

Link to Mohana Article

I do it in a different way which is kind of similar to Kerry & Mohana , I used it for quite some time for Filtering objects in object designer While Merging a Rollup.

So this is how I do it, for example i will stick to same Records i.e customers as Kerry & Mark used.

I copy a few lines to excel like this:

And in Excel I paste, and copy the number column -

And I paste and Move First customer to Next column but in same row -

In Second Row use a Concatenate Formula -

Drag / Copy to Formula till last customer -

The Last row now can be copied and pasted as Value in different cell to get Filter.

There I have the filter.

Now we have three options. Maybe there are more.

Thanks again Kerry!, Mark! & Mohana!

Stay tuned!.

Saurav Dhyani

No comments:

Post a Comment

Popular Posts