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.
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.
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.
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
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?
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. 😣😣😣
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.
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.
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!
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. 😣😥
XLOOKUP AND XMATCH are not available in Google Sheets at the moment, but you can get similar results using the method in this video ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gY7fVMGP7Dk.html
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?