Looking for a way to get a MIN result across a row of numbers but after a randomly chosen spot. Ex. Row 1 ( Commas are separate cells ) 455,2,223,5667,32323,56,3,2323,34 I have used the MAX function to locate the MAX value in Row 1 EX - 32323 I need to Return a MIN result after that MAX number position. EX - 3 The MAX will be in random spots every time I input data into a new sheet.
Solved by M. U. in 30 mins