如何提取一行数据中最后一个非空单元格的列号,如以L2:CK2为例,该怎么...答:COLUMN(L2:CK2))或者=IF(LOOKUP(1,0/(L2:CK2<>""),COLUMN(L2:CK2))>26,(LEFT(ADDRESS(ROW(),LOOKUP(1,0/(L2:CK2<>""),COLUMN(L2:CK2)),4),2)),(LEFT(ADDRESS(ROW(),LOOKUP(1,0/(L2:CK2<>""),COLUMN(L2:CK2)),4)))第一个是数字列号,第二个是字母列号。向下复制 ...