minimum value

I have a simple table showing a list of golf scores with the name of the person and the date of the round. From this list I want to be able to put in a separate table the date and lowest score of each of the players Name Score Date Name Date Best Score Terry 73 01/05/2019...

Hello, I have a list of cities with distances and travel times between them. Postal Code is only for further identification of the city or city part. The table looks like this (with a total of 60000 rows): <tbody> Postal Code 1 City 1 Postal Code 2 City 2 Distance(km) Travel time(minutes)...

Hi there, I have some keyword ranking data that I am trying to find the number of weeks since the best rank. Currently using the no. of weeks reported on minus a match on the best rank. However the issue with this is that the match lookup selects the leftmost minimum value which disregards...

I have 3 cells with values either 0 or a numerical value(non negative). In 4th cell MINIMUM of the 3 cells are required without considering cells with 0 value. Sheet1 <colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH...

My 'actual' range is AC38:BH38 which contains values or "" & I want to get the Second MINIMUM VALUE from this 'actual' range in final cell address HF38. There is a helper row $AC$58:$BH$58 which contains "Y" to certify that the corresponding cells in the above row 38 contains values & not "" &...

I've got a range from I9:I16 that I need the minimum positive value for. The problem for a =MIN array formula is that at times there may be a #VALUE error in these cells. Within these cells there are formulas that have changing numbers based on inputs from a separate part of the excel sheet...