SOLVED
how to identify
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
hi2019
8 - Asteroid
‎08-14-2024
09:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I want to identify any , inside the Payee name column - would that be a fomula? or filter?
I would like to create a column with these so I can then create another formula that has comma, plus other things to have them filter out to another MAnual tab.
Example :
If [Payee Name Count] = '1'
AND [ID Codes] != 'ENT'
AND ------------if payee name has commas
THEN 'Manual Review'
else [Sheet Name] ENDif
Solved! Go to Solution.
Labels:
- Labels:
- Reporting
1 REPLY 1
14 - Magnetar
‎08-14-2024
09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
