Excel - Find Last Non-Blank Cell Value, Row or Column

Find last non-empty cell value, row or column in Excel.

#excel #find #last

[AzMetsFan]

Huge help and really appreciate you taking the extra step to show the nuances of capturing text and numbers. Thank you!

[supermansflu]

THANK YOU! I have been struggling with trying to figure out this concept for way too many hours!

[barderians]

I can't show you how happy i am that you have solve me some big time. Thank-You🙏

[JHatLpool]

Great video. Your demonstration has helped me alot with a current issue that I have in Excel. Thanks for posting !

[pouyan]

Worked like a charm -- worked like how "Expelliarmus" did for Harry Potter! Thank you so much!

[Nevir]

LOL I've watched this so many times. Every thing I think I remember it well enough to implement it myself I mess something up, it KINDA seems to be working, and then everything goes to hell and I just have to come back and watch again.

[zulfi]

Thank you so much for sharing! It helped me a lot!

[races]

Can this formula be adapted to exclude "0" values in the source data? In other words, if I have a "0" present in the lookup/return array field, I would like it to ignore that cell and move on to the next one that has a value larger than "0"

[sachidanandsadhguru]

There is no VALUETOTEXT function in Google sheets. What do I do then?

[chandrababuravi]

hi, Can you show how the XMATCH works for numeric data instead of text

[breckoz]

I would like the last value text that does not include 0.00. Is there any way to add that exception to the formula used in this video(XLOOKUP with VALUETOTEXT)? I am choosing cells B5:B57

[samuelisreallyhere]

hello, is there a way to apply this to google sheets? the functions xmatch is present in sheets, but trying to use it for a alphanumeric dataset doesn't seem to work. im using "=XMATCH("*?*", to_text(P:P), 2, -1)" and all it does is return "1". the result should return "8" if everything's working properly. what am i doing wrong?

[robbieflores]

Is this possible on a non Excel 365 version?

We only use 2007, 2013 Excel version in our company

Hope you can help me because this is exactly what I need. 😣😣😣

[bistaggamer]

XLOOKUP is not available in Excel 2016 and Excel 2019...

[ewad.]

Very useful ! You helped me with my work issue, thank you !!!

[werd]

Thanks for posting this reaaly helpful video. Is it possible to determine the last 3 columns that contain values within a row that may have several blank cells, ie columns 1 - 20 contain 5 values and 15 blank cells (value, blank, blank, value, blank, value etc). Hope this makes sense.

[biswanathpan]

How to get Date by using this formula?

[monikab.]

Thank you for posting! The last formula is very close to what I'm looking for, except for a number of columns I'd like the column name... Is there a way to tweak the last formula, or I'd have to use a completely different one? Many thanks for sharing!

[robbieflores]

After installation of ExcelDna.Xfunction64, XLOOKUP function already appeared but not VALUETOTEXT Function and it only works in 2013 Excel version

Hope you have another formula for the same purpose for 2007 & 2013 Excel version.
😣😥

[mikejpaulus]

I am trying to use the xmatch command in a macro to get the last row number to create a pivot table. I get an error in lr=xmatch("*", A:A, 2, -1) that there is a Compile error: Expected: list separator or ) and the colon between the A's is highlighted. What should I be doing different?