SOLVED
Counting Number Range
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
Jenina
8 - Asteroid
‎03-08-2024
02:46 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Community,
Is there a way to count the number range from a column. Similar function to number filters in excel.
Please see attached sample, the color matches the output.
Thank you!
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
5 REPLIES 5
binuacs
21 - Polaris
‎03-08-2024
03:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jenina a batch macro should work on your use-case
‎03-08-2024
04:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs It works! Thanks as always
‎03-11-2024
11:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Hello! I ran the workflow today and saw an amount more than 5mm, but it doesn't reflect on the output. I saw the formula was already in ABS so not sure why.
File attached.
Thanks!
binuacs
21 - Polaris
‎03-11-2024
02:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Jenina There was a space in the flag6 name which was causing the issue, updated workflow attached
‎03-12-2024
03:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Got it, thank you!
