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.
For the fields 1-9 how do you decide whether it is the higher or lower value you want each time?
Happy to help : ) @jaygerbs
Cheers and have a nice day!