Hi all,
so im currently trying to solve a porblem. I wrote a function that shows me the maximum in regards to a set category. For example, in the attached file, in row 2 the formula [F2] looks up the maximum value in the row (which is 74 [C2]) and then prints the catagory [C1]. In this case: "afternoon". However I am only intrested in true maxima. Meaning if there are equal values like in row 6, I dont want the formula to print "morning" [F6] but rather leave the field empty or print something diffrent like "0" or "both".
Does anyone know how to achieve this?
Kind regards
MrMoody
Bookmarks