I have a list of numbers in one column and I want another cell to return the next number. This works with the formula for example =MAX(A1:A500+1
However I now need to also have text in the list, so instead of 1,2,3.... where the formula would tell me 4 is next, it would have something like PO_1
Currently entering text makes the formula do nothing, can anyone advise?