Forum Discussion
Get index of last column with any data in a row
I can get the last column with any data in a row using this formula as described https://excelchamps.com/formulas/lookup-last-value/#Lookup_for_the_Last_Value_from_a_Row =LOOKUP(2,1/(1:1<>"")...
If under the index you mean column number, as variant that could be
=LOOKUP(1E+307,COLUMN(1:1)*IF(1:1="","",1))entered as array formula (Ctrl+Shift+Enter) on other than 365 or 2021 Excel.