SOLVED
Comparing columns and selecting lower or higher values in those rows
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
jaygerbs
7 - Meteor
‎01-07-2022
01:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am willing to bet this is pretty easy for the experts!
If column 1 (UN) contains duplicates I'd like to compare the other rows of the duplicate UN and select either the lower or higher value. Then the output would be one row for each UN
Example below:
UN | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
User 1 | 00:34:56:75 | 5.2 | 1058 | 9534 | 4.5 | 00:00:11:32 | 4.1 | ||
User 1 | 00:00:08:36 | 6871 | 2.5 | 5.6 | |||||
User 1 | 00:38:26:65 | 1.2 | 6842 | 4.65 | 00:38:26:65 | ||||
OUTPUT | |||||||||
User 1 | 00:00:08:36 | 00:34:56:75 | 5.2 | 6842 | 9534 | 4.5 | 4.65 | 00:00:11:32 | 5.6 |
Solved! Go to Solution.
Labels:
- Labels:
- Developer
5 REPLIES 5
binuacs
21 - Polaris
‎01-07-2022
01:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
14 - Magnetar
‎01-07-2022
02:24 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
For the fields 1-9 how do you decide whether it is the higher or lower value you want each time?
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
binuacs
21 - Polaris
‎01-07-2022
11:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎01-08-2022
12:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
22 - Nova
‎01-13-2022
08:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Happy to help : ) @jaygerbs
Cheers and have a nice day!
