I have been trying this function(?) but the results are confusing. If I try it in column A it works (not that I need to use it in this column because it is in sequential order) but when I use it in column B, which contains the same numbers but out of sequence following the sorting previously discussed, it returns zero. Is it the case that you cannot use the MAX function in columns that have been sorted? Or, perhaps it should be applied before sorting to make it work.