Excel - Last number or text | Excel Tips 106
In this Excel tutorial, you will learn How to find the last number or text in range | Excel Tips 106
Want to get 3 chapters of the Excel SuperHero book? Sing up: https://ExcelAndAdam.com/book
Used formulas:
=XLOOKUP(TRUE,ISNUMBER(A2:A12),A2:A12,,,-1)
=XLOOKUP(TRUE,ISTEXT(A2:A12),A2:A12,,,-1)
=INDEX(A2:A12, MAX(IF(ISNUMBER(A2:A12),ROW(A2:A12)-ROW(A1))))
=INDEX(A2:A12, MAX(IF(ISNTEXT(A2:A12),ROW(A2:A12)-ROW(A1))))
=LOOKUP(2, 1/ISNUMBER(A2:A12),A2:A12)
=LOOKUP(2, 1/ISTEXT(A2:A12),A2:A12)
--⏱️Timestamps⏱️--
00:00 | Last number with XLOOKUP function
01:33 | Last text with XLOOKUP function
02:10 | Last number or text with INDEX function
06:10 | Last number or text with LOOKUP function
08:47 | The End
================
Files to download in the Eng folder on the website:
http://exceliadam.pl/youtube
You can also find me on:
📚Blog - https://excelandadam.com/
🍀Instagram - / excelandadam
🌟Tik Tok - / excelandadam
✨Facebook - / excelandadam
🕊Twitter - / excelandadam
#ExcelAndAdam #ExcelTips #excel