Pulling Row Data for each Max Value from a ColumnI have a table with the first column being my time varying X-axis variable and all the remaining columns being the Y-axis response columns. I'm looking to create a subset table based on the Maximum value of each Y-axis column. I.E. The subset table should be all the rows in the original table that have a Maximum value in one of the corresponding Y-axis columns. That way I can compare at what X-axis value all of my Y-axis maximums occurred. (Even better would be the X-axis value paired with the single Y-axis maximum, but we'll get there later)
Is there a simple way to do this through Summary or Subset tables?
Basic Data Analysis and ModelingData Blending and Cleanup
