Please see attached file.
I need the value from the User column, which user column determined by the last non-zero data from the review column in the row.
On line 2, formula would return 12939 from column H, because 711 in column G is the last non-zero review data in the row. But on line 9, formula would return 90002 from L, because 75 in K is the last non-zero review data in the row.
So, whatever the last review number is in the row, find the user number after it, and that should be result of the formula.
I've tried all sorts of things with the COLUMN function and such, but it's just not going. Any help? Oh, my users don't even know what VB stands for, so I can't wow them with any code. They need a formula they can understand.