Excel Magic Trick #134: Find Last Value In List
Loading...
Loading...
3,804
Loading...
Uploader Comments (ExcelIsFun)
see all
All Comments (7)
-
Very helpful for a section of my personal financial planning workbook that I've been working on. Thanks a ton!
-
Dear PrincessWithSkills,
That is awesome!!
EXCELlent!
Yes, that moment when you begin to get it feels great and it is called an epiphany! If we can have 25 or more epiphanies in a day, we know we are having a good day!
--excelisfun
Loading...
6:38
Excel Magic Trick #135: Find Last Row & Column Dynamic Rangeby ExcelIsFun8,628 views- 10:21
Excel Magic Trick #124: Box Plot or Box & Whiskerby ExcelIsFun90,789 views
- 7:07
Excel Magic Trick #133: Import CSV Data (Comma Separated Values - Data)by ExcelIsFun16,035 views
- 8:45
Excel Magic Trick #176 Get Last Item in Column on Diff Sheetby ExcelIsFun2,778 views
- 5:48
Excel Magic Trick 341 Extract Data w OFFSET & INDEX functionby ExcelIsFun13,100 views
- 7:55
Excel Magic Trick #130: 3 Dimensional Database in Excelby ExcelIsFun23,408 views
- 4:13
Excel Lookup Series #8: MATCH Functionby ExcelIsFun70,456 views
- 8:20
Find the last row of data in an Excel columnby peterdcasey1,817 views
- 7:17
Mr Excel & excelisfun Trick #6: Get Last Value In Rowby ExcelIsFun6,209 views
- 8:18
Excel Magic Trick # 254: Data Table Creates 100 Formulasby ExcelIsFun26,099 views
- 2:54
Excel Magic Trick #92: Two Chart Types In One Chart!by ExcelIsFun21,245 views
- 4:29
Excel Magic Trick #119: Is Item In List? 2 Examplesby ExcelIsFun4,374 views
- 2:55
The OFFSET Function V2by AuditExcel3,103 views
- 8:48
YTLE#105: Excel OFFSET for Dynamic Range in Functionby ExcelIsFun21,810 views
- 8:08
Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Listsby ExcelIsFun7,576 views
- 3:54
Excel Magic Trick #120: ISNUMBER & SEARCH functionsby ExcelIsFun7,828 views
- 8:02
Excel Magic Trick #111: Build A Questionnaireby ExcelIsFun25,132 views
- 4:54
Excel Magic Trick #128: VLOOKUP Categoriesby ExcelIsFun8,790 views
- 6:50
Excel Magic Trick # 160: Find & Replace Format or Formulaby ExcelIsFun14,233 views
- 3:20
Excel Magic Trick #141 part 1: Day Numbers to Datesby ExcelIsFun4,250 views
Very helpful. Thanks for the post!
ioj27 10 months ago
You are welcome!
ExcelIsFun 10 months ago
Hei!Thnx for great videos!! have reached EMT 134, and I just noticed that method 2, tollerates many empty rows between two values and still deliveres the last value, while method 1 and 3 just tolerates one empty row...I still use 2003....
cunheco 1 year ago
Cool!
I am glad that the videos help!
ExcelIsFun 1 year ago
I'm beginning to get it. Like going to control+G+99 in Word, to the end of the document.
PrincessWithSkills 2 years ago
Dear PrincessWithSkills,
Instead of Ctrl + G + 99 in word to get to the end of the document, use this faster method:
Ctrl + End.
To get to the top use:
Ctrl + Home.
--excelisfun
--excelisfun
ExcelIsFun 2 years ago