Hi,
My issue is that I have a Data set where most of the values are constant the total of these is 100´, but one value will either be included or not depending on the day, lets call this X. I have used =MIN(A:A;5) to retrive the fith smallest value, but this only works on the days X is not included. Would it be possible to use an IF statement? My idea (in theory) is "if the total of all values equals 100´, look for fith smallest. If the total of all values is more that 100´, look for sixth smalles". Is there a way to formulate this?
Thank you in advance, and sorry for a quite confused explanation of the issue.
// Your Excel Rookie.
Bookmarks