I've got a list with productnumbers. Like this:
All numbers are RS followed by four numbers.
I use the following array formula to find the highest number:
However the list goes further than B100, but I can't use B:B because there are also empty cells in column B which gives #Value!.
How can I get this formula to ignore blanks?