SOLVED
Dynamic Select - Choosing Even Numbers
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
furlonla
8 - Asteroid
‎02-16-2021
08:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have summarised some data with a description ID column (group by) and counted (count) the occurrences of these IDs.
I want to separate the counts with an odd/even number, if anyone has any idea how I can do this, that would be great!
For IDs with a count of 3, I would like a new column to say 'unique' for one of them and 'duplicate' for the other two IDs
Thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Developer
- Developer Tools
4 REPLIES 4
17 - Castor
‎02-16-2021
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
13 - Pulsar
‎02-16-2021
08:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I usually use the Mod formula to fine evens and odds. You can use this formula:
Mod([NumberColumn], 2)
If the result of this formula is zero, then it is even.
‎02-16-2021
09:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks, I have been able to use this to select the even/odd numbers. Is there away to manually put in say first four rows = Duplicate, fifth row = Unique
‎02-16-2021
09:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Got it using a multi row formula!
