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

[@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!

[@Nevir202]

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.

[@davidlemossanchez6272]

YOU SAVE ME IN AN INTERN PROJECT!!

[@barderians]

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

[@ExcelGoogleSheets]

Glad to hear that

[@JHatLpool]

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

[@zulfi1969]

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

[@AaronMatthewBeharry]

Thank you so much!

[@pouyan74]

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

[@ExcelGoogleSheets]

👍

[@sachidanandsadhguru3703]

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

[@A2l-mm]

Thanks ALOT... I need this

[@ewad.6619]

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

[@ExcelGoogleSheets]

Great to hear!

[@samuelisreallyhere921]

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?

[@andrewclarke4188]

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.

[@Nevir202]

Yea, there may be an easier way to do it, but if nothing else, you could use a LET formula to search a range, to get the last non-blank. Then use drop so that you have restricted that range to 1 less than your first result. That will give you the second to last, repeat that again to get the third from last. Then output those 3 resulting numbers.

[@chandrababuravi7951]

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

[@bistaggamer]

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

[@emadkawekji8820]

Many thanks.

[@pvv_live2226]

Very nice video👍

[@ExcelGoogleSheets]

Thank you very much!

[@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

[@robbieflores4780]

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. 😣😣😣

[@vicentefigueroatocornal2776]

Thank you

[@ExcelGoogleSheets]

👍

[@monikab.6540]

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!

[@monikab.6540]

by column name, I actually mean table column name (not column "A" for example)... thank you!

[@biswanathpan1756]

How to get Date by using this formula?

[@pvamshikrishna3169]

Greate video sir..... Can you do a video for Geographical Info (Geocode: Longitude/Latitude) to Google Forms. there are no options for geolocation in the google form and also there is no add-on for it.

[@ExcelGoogleSheets]

This will not work in Forms, at least the way Forms is designed now. You will either need a Web App or you will need to add lat/long in the spreadsheet after the address was already populated.

[@pvamshikrishna3169]

@@ExcelGoogleSheets Thanks for your response ..!

[@BharatRasoi]

Nice 🙏🙏

[@ExcelGoogleSheets]

Thank you! Cheers!

[@robbieflores4780]

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. 😣😥

[@ExcelGoogleSheets]

Something like this should work if you apply the formula with ctrl+shift+enter =MAX(IF(A1:A1000="","",ROW(A1:A1000)))

[@david_sdiego]

Good for Excel but "VALUETOTEXT" function is unknown to Google sheets. I use =INDEX(B2:B,COUNTA(B2:B)) but you can't have blank rows with this.

[@ExcelGoogleSheets]

Use TEXT(val,"@") instead of VALUETOTEXT

[@trilochanjena3836]

how to show last filled cell value in a userform vba excel

[@mayurkhatri1048]

Very nice video 👍. Is there something similar in google sheets? I believe XMATCH AND XLOOKUP do not work on google sheets.

[@ExcelGoogleSheets]

XLOOKUP AND XMATCH are not available in Google Sheets at the moment, but you can get similar results using the method in this video kzbin.info/www/bejne/nYqal4mDfLVqes0

[@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?

[@mikejpaulus]

I get the same error using the xlookup as well.

[@ExcelGoogleSheets]

In macros do this kzbin.info/www/bejne/hKO8dXR7qL6WmLc

[@mikejpaulus]

@@ExcelGoogleSheets I had originally tried that one and I get an error. This is what I have lr = Cells(Rows.Count, 1).End(xlUp).Row

[@ExcelGoogleSheets]

@@mikejpaulus Where is your data located?

[@ExcelGoogleSheets]

What does the error say?

[@thehawk40375]

Can you send me the google sheet format of my excel sheet

[@ExcelGoogleSheets]

I don't understand the question

[@sumits6442]

first non-empty comment

[@ExcelGoogleSheets]

:)

[@neelalam]

Thanks a lot. L O V E

[@FireCrauter]

en español: =COINCIDIRX("*?*";VALORATEXTO(B3:B37665);2;-1)