100 hours and 200 so called excel gurusr, criss cross the desert, given up hope, suddenly miraculously this Oasis- where I found what I need to know. Thank you 😘
@ExcelGoogleSheets
Жыл бұрын
🙂
@kafayat-khattak
2 жыл бұрын
Hello! I'm from Pakistan and I work for Florida based insurance company remotely as a freelancer. I get a lot of help from your channel. Thanks man. I ❤️ you. Mwah 😘
@ExcelGoogleSheets
2 жыл бұрын
:)
@edpowers4771
Жыл бұрын
Just wanted to say this worked great! Thanks for the help!
Nice, thanks! How would you do if the other report from where we are getting the columns had some filters on those columns which you want to bring to another sheet? Do you have any videos of that? Thanks
@ExcelGoogleSheets
3 ай бұрын
Formulas will ignore filters. You'll probably need to use FILTER function to filter your data again.
@EdwardHandshy
Жыл бұрын
Finally the right info
@fyew9517
9 ай бұрын
exactly what I need
@saimanikantakumarnulu4650
10 ай бұрын
Thank you 😊
@jamesepace
2 жыл бұрын
Good stuff! How about an array for the first xlookup() argument? Save all that copying down.
@ExcelGoogleSheets
2 жыл бұрын
Sure, you could do that. Since I tend to convert things to tables in Excel, I'm not concerned about copying down, it happens automatically with tables anyways.
@balamira297
2 жыл бұрын
Very informative
@ExcelGoogleSheets
2 жыл бұрын
Thank You!
@emilianoreyes
2 жыл бұрын
Thank you!
@ExcelGoogleSheets
2 жыл бұрын
:)
@InsightKnowlege
Жыл бұрын
Hi mate, I am one of your subscriber and learned how to xlookup on csv files. I use xlookup in csv file to update shopify shop inventory as shopify only accept csv format. But the problem is when you use xlookup and after you close the file the xlookup function does not save and lost the formula. Please help if this is something wrong with my version of excel or the formulas doesn't not work with csv format. By the way i am using the lasters version of Microsoft 360.
@ExcelGoogleSheets
Жыл бұрын
File-Save As change to an Excel file.
@azhadshamim3122
2 жыл бұрын
Great explanation 👌
@ExcelGoogleSheets
2 жыл бұрын
Thank you 🙂
@teoxengineer
2 жыл бұрын
Good. Let's assume that if we have multiple values in a ragne and want to extract different values from list by using xlookup. How can we manage it?
@ExcelGoogleSheets
2 жыл бұрын
Do you mean multiple row matches or simply multiple columns?
@teoxengineer
2 жыл бұрын
@@ExcelGoogleSheets Multiple row matches...Same name but different values
@ExcelGoogleSheets
2 жыл бұрын
@@teoxengineer Not possible with XLOOKUP, but you can do this kzitem.info/news/bejne/0JCeyZejioZ5nnY
@mrbrooks256
2 жыл бұрын
In your opinion, whats the best way to find a cell containing "abc" or similar value in it and copy its entire content to another sheet? Ive tried LOOKUP, MATCH, INDEX with no sucess.
@ExcelGoogleSheets
2 жыл бұрын
=VLOOKUP("*abc*",rangeToSearch,1,0)
@mrbrooks256
2 жыл бұрын
@@ExcelGoogleSheets it says that the answer is a text and therefore cannot be force into a number. In my case i have a scrambled database, in wich my columns arent where they are supposed to be, so iam tryin to copy the cells containing certain words in the right column in other sheet
@mrbrooks256
2 жыл бұрын
@@ExcelGoogleSheets Nevermind, it worked, thank you so much
@murthy010873
6 ай бұрын
Bro Need POWER QUERY video pls
@azhadshamim3122
2 жыл бұрын
Hello Sir I am from Doha Qatar 🇶🇦 How to leave 1 or 2 columns and then value Plz explain Like I have in column 2 ID and then 2,3,4,5 columns for the remarks manually and then I want to get the value Thank you
@ExcelGoogleSheets
2 жыл бұрын
Do you have HSTACK function available in your version?
@azhadshamim3122
2 жыл бұрын
@@ExcelGoogleSheets thank you so much Sir, I got idea from your video So it's solved Thanks again
Пікірлер: 39