![Contributor III](/html/@7F22A031F429FE81AFED819B1E5863E0/rank_icons/Community_Gamification-Ranking-Icons_16x16-Contributor.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If Match Multiple Criteria
Hello,
I'm trying to return a list of cases which fall in the criteria below:
Unrun_Drivers=1
Time Standard=7
Expedited= N or A
Action= Application or Additional Benefits.
I tried if match but that didnt work. Thank you for any help.
=If(Match(Unrun_Drivers='1',[Time standard]='7',[Expedited]='N','A',[Action]='Application','Additional Benefits'),([Access Number]))
Accepted Solutions
![Specialist](/html/@0E4DF50C0A668F4F5116BEB444E8EE31/rank_icons/Community_Gamification-Ranking-Icons_16x16-Specialist.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using set analysis criteria and the aggr() function, something like this:
=aggr(only({$<[Unrun_Drivers]={'1'},[Time standard]={'7'},[Expedited]={'N','A'},[Action]={'Application','Additional Benefits'}>} [Access Number]), [Access Number])
![Specialist](/html/@0E4DF50C0A668F4F5116BEB444E8EE31/rank_icons/Community_Gamification-Ranking-Icons_16x16-Specialist.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try using set analysis criteria and the aggr() function, something like this:
=aggr(only({$<[Unrun_Drivers]={'1'},[Time standard]={'7'},[Expedited]={'N','A'},[Action]={'Application','Additional Benefits'}>} [Access Number]), [Access Number])
![Contributor III](/html/@7F22A031F429FE81AFED819B1E5863E0/rank_icons/Community_Gamification-Ranking-Icons_16x16-Contributor.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you
![](/skins/images/FF3D8C2C7F3DC4DBFEE5281D76AA3012/responsive_peak/images/icon_anonymous_message.png)