Hi all,
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOiRjV0JpYqqbF-YpfkCtG9pJPfSG1js0HsOh898yoxIJTUAglHPoknC4xE_jfKPUJqe4gSFknWz-Amj1bmI15YEOUP_XBqpc7P1X7QGu1LuQlkbSGtMNWMfNCqO_jzxXx65LdMKJQ-IPB/s1600/Tip2.jpg)
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 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!.
Regards,
Saurav Dhyani
saurav-nav.blogspot.com
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOiRjV0JpYqqbF-YpfkCtG9pJPfSG1js0HsOh898yoxIJTUAglHPoknC4xE_jfKPUJqe4gSFknWz-Amj1bmI15YEOUP_XBqpc7P1X7QGu1LuQlkbSGtMNWMfNCqO_jzxXx65LdMKJQ-IPB/s1600/Tip2.jpg)
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!.
Regards,
Saurav Dhyani
saurav-nav.blogspot.com
Comments
Post a Comment