Comparing columns and selecting lower or higher values in those rows

[jaygerbs]

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

[binuacs]

@jaygerbs 

[cgoodman3]

For the fields 1-9 how do you decide whether it is the higher or lower value you want each time?

[binuacs]

@jaygerbs I updated my workflow so that the min value will be selected for the time fields

[atcodedog05 · Accepted solution]

Hi @jaygerbs 

Here is my take on it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @jaygerbs 

Cheers and have a nice day!