Filter Multiple data at a time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-10-20 05:04 PM
I have one collection where column name is "Block reason" = Sales Block, pricing block.
I need to filter out all blocks at a time and want to keep " " = empty cell. How would I write filter collection code. Please help me asap. Its urgent.
------------------------------
Asitabha Deb
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
23-10-20 07:42 PM
------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------
Dave Morris, 3Ci at Southern Company
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-10-20 03:35 AM
For eg = Sales Order# 6058795782-100 = Pricing Block
6245893578 - 100 = Sales Block
6289745230 - 100 =
I want to filter out all the sales orders which has under block at a time and only keep SO# 6289745230 - 100 as it has under no block.
I hope now you understand what I mean.
------------------------------
Asitabha Deb
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-10-20 04:25 AM
Hi,
Is this inside one cell or in 3 seperate rows and are 3 seperate column, would be better if you can attach a screenshot.
Thanks,
Gopal
------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-10-20 06:26 AM
1st column 2nd Column
Sales Order No Block Reason
6058795782-100 Pricing Block
6245893578 - 100 Sales Block
6289745230 - 100
I want filter only 3rd SO.
------------------------------
Asitabha Deb
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-10-20 10:08 AM
Filter Collection:
" [Block Reason] = ' ' "
(Just delete the space inbetween the single quotes - I have left it in to show they are single quotes and not double quotes)
------------------------------
Matthew Blease
RPA Developer
Lloyds Banking Group
Europe/London
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
27-10-20 12:07 PM
As this is a huge excel file I am unable to apply filter. So, I want to apply filter directly in the Column.
Will it be possible. If yes, how?
BR/Deb
------------------------------
Asitabha Deb
------------------------------
