I've currently got;
=IF(A6="","","Supplier Perfomance " & MONTH(A6) & " " & YEAR(A6))
but of course, this gives the month serial, not the word of the month.
HansV wrote:BTW, shouldn't it be "Performance" instead of "Perfomance" in the formula?
Click in any cell of the data area.Egg 'n' Bacon wrote:Is there a setting to sort the results on refresh?