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.
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.
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
Got it using a multi row formula!