In column range A-Z, row 1, there are cell values in E1, M1, Y1, the rest are blank. What functions can I use to determine the far most right column containing any value, in this case Y?
They also declare 'blank', given that MATCH("zzz" will see formula blanks as text, maybe Yongle is the only one of us who got it right
If they are empty, then an additional formula for mixed data types.
=SUBSTITUTE(ADDRESS(1,AGGREGATE(14,6,MATCH(CHOOSE({1,2},1E+100,"zzzz"),1:1),1),4,1),1,"")
In column range A-Z, row 1, there are cell values in E1, M1, Y1, the rest are blank. What functions can I use to determine the far most right column containing any value, in this case Y?