MIN function returns the same value for every row

[Wanderer86]

Hi
In column D I have the time of the end of my shift. When I try to input =MIN(1;$D:$D) in column E, i get the same answer (0,625) for any row, while =$D:$D gives correct values. So I guess it has something to do with the MIN function, but I can't figure out what it is. Anyone know why this is occuring?

Thanks

[AlKey]

Hi and welcome to the forum

Try =MIN(D:D)

[Wanderer86]

Thanks AlKey
I tried your solution, but it's still not working. It seems it takes the minimum value of the entire column, while I want the minimum value of "1" and the value in column D in the same row as the formula is in. E4=MIN(1;$D4:$D4) gives the right value, while E4=MIN(1;$D:$D) gives the minimum of 1 and every value in column D. I to simplify my formulas by using name references, in this case I tried to use "EndShift" instead of referencing each cell for each row, like this E4=MIN(1;EndShift). I probably made it more complicated by doing so ;P

[AlKey]

I suggest that you upload a sample spreadsheet with about 10-15 rows of data so we could figure our a solution for you.

To upload a file click on Go Advanced on the bottom of your screen, then click on paperclip icon and Add Files.

[Jonmo1]

Try this in E4

=MIN(1,D4)

[Wanderer86]

MIN function example.xlsx
Here is the example spreadsheet

[Wanderer86]

@Jonmo1
I'm trying to make the spreadsheet more readable for other users, so I wanted to use naming references instead of directly referencing the cells themselves, but it's probably more trouble than its worth :p

[Jonmo1]

but it's probably more trouble than its worth :p

+1

Reading a cell reference is about as simple as it gets in Excel.

[Jonmo1]

You could do this in the Named Range reference

=INDEX(Sheet1!$B:$B,ROW())

However, this is now a Volitile funciton and will reduce sheet performance.

Back to the "is it really worth it" argument.

[Wanderer86]

Yeah, we dont want reduced performance

[Wanderer86]

I don't think its possible to do it the way I was thinking without making it volatile, and I'm probably the only one who is going to be using this spreadsheet anyways, so I'm marking this as solved Thanks for the help though