Good day
I need to determine the min and max weight per day.
My excel spreadsheet do have al the days of the month with Weight against a certain time during the day. I need to know what is the min & max weight for each day.
Thank you
Hello Ethel,
Welcome to MOTH. How do you want it to be presented? Highlighted using conditional formatting or using some kind of report form? Anyway, there is one issue to correct.
Column D, your dates are not proper Excel dates in a number format, they are text. So this needs to be corrected. I have done so in column G. In the attached file I have three different variants to get and show the min and max weights per date/-s.
You can also read more on how to get the MIN/MAX values in this post.
Br,
Anders
Thank your Anders. This is exactly what I need to do. On the same excel spreadsheet there is a column with Time (Column E). I need to have the earliest time and latest time per day, like you explain to me with the Min & Max per day Column L & M). Then I will be able to work out total hours per day. Is it possible that you can also help me with that?
Kind regards
Ethel
Hello Ethel,
I have added two more columns, N and O, showing earliest and latest time for each date.
I hope this gives you the help you want.
Br,
Anders
