Skip to main content
2 of 2
edited tags
αғsнιη
  • 41.9k
  • 17
  • 75
  • 118

find the min and max value in two columns

I have some data which looks like:

sampleA ATGC 10 100 sampleA ATGC 120 230 sampleA ATGC 200 110 

I want to print the min and max using the values in both column 3 and 4. So my output should look like:

sampleA 10 230 

Thanks in advance

AudileF
  • 185
  • 3
  • 11