Riiight!?!?!? Microsoft keeps giving us new eras like DATA Model and DAX, Power Query, Power BI, Dynamic Spilled Array Formulas and the new worksheet calculations engine, LET function, LAMBDA functions, Picture in Cell... They are very good to us : ) : ) : )
Wow: that would be up to an even higher level: show in dropdown and Power Query : ) : ) Thanks for your kind words about my teaching! I love being on the Team with you too, Softwaretrain awesome teacher : )
Hi, Mike. Great video as always. This picture in cell is great even better is that you can use the cell as part of a formula. Excel just keeps getting better and better!
Finally I got my doubt cleared on entering a barcode of a product gives it respective image... Let me tell you one thing I have nearly 40-42k products and I need to arrange them and represent them by product category,weight,supplier and most importantly by amount....now I got the solution You just ....just......just.....saved my life..... Thnkssss....mike ... Lucky to have a teacher like you... One more thing to tell you... Why dont you start a complete course of data science....it is my humble request you to look forward to it.... And again thankkkkkkkkkkkkkkkkkkkk.......you ❤❤❤❤❤❤❤❤
Hi Mike, saw a few videos of this new feature, and thought it just going to be very similar, but you blew this right out of the water. Never did I imagine doing lookups on the pictures.
Yah, new Neta features do not flow out to all beta subscribers at the same time. I got this feature a few weeks late... But I kept looking and today it popped up so I had to make a video. I never imagines either... : )
Great feature 👍👍 and salute for your hard work 👏👏 because of your channel I have been becoming expert in excel.. You're my motivation 😊 Thank you so much for your videos 🙏
@@excelisfun Since YT turned e-mail notifications in 2020 I am missing a lot of your videos. Mobile notifications are useless, they just don't work for my "watching style". I used to have some e-mail notifications in my inbox and used to watch all videos in the evening when I have time to do it. After watching I used to delete those notifications. The lack of those notifications completely messed up my YT watching routine :/
@@pmsocho That is the same thing that happened to me. I get no more notifications. It really makes following difficult. That is what happens when RUclips and Google became a monopoly... : (
Great video!! ✌ The pictures act like any other values , copy, paste, paste as values, unique, all work even SORT does something (no operations, math or any kind work) . The coolest part, they can be lookup values so this formula works fine. ( Sheet 1822 (an) ) Having only the picture can retrieve all the info. =XLOOKUP(J5:J7,Pa[[#All],[Picture]],Pa[[#All],[Product]]) Will all the AI capabilities, soon enough, will be able to search using different pictures of same item. In Excel. 😉
Another trick. A compromise solution until will have a ISPICTURE function. (like ISNUMBER, ISTEXT, ISLOGIC) If we have a column vector that has mixed data and pictures, an easy way to filter only the pictures. If we append empty string to any data type will get text (no error) , if we do it to a pic will get an #VALUE error. Replace some of the pics in C5:C12 with some numeric or text values. To filter only the pictures: =FILTER(Pa[Picture],ISERR(Pa[Picture]&""))
Hey, Mike. I am planning on getting a new laptop since I’ve had mine for a while now. I was wondering if you had any recommendations. I’ve just started my excel journey and am planning to keep improving and learning as much as I can. I am planning on using this laptop for Microsoft Office, mainly Excel. Please let me know if you have any personal favorites or recommendations from your experience.
I have a bingo game that I want to create with pictures. Is it possible to be able to randomly sort each column so that I can make 20 bingo cards for my classroom?
Here is a video I just made for you: ruclips.net/video/gW84oK2mpGw/видео.html But look at the pinned comment below the video, it has an even better formula.
@@excelisfun thank you so much for creating the video, I tried the formula, but it didn’t work. I’m assuming because the feature is in beta test. Is there a way for me to get this done?
Wow you can find a student's or person 's identity once you got his or Her picture through cctv in either college Record or National data base... is it so??
Yes! Finally, we get to see those boomerangs that you've made famous over the years Mike.
Yes!!!!!! Boomerangs are better in visual form : ) : )
Small and simple videos make Excel very easy to understand, that certainly come from a great teacher, thank you Mike
You are welcome!!!!
Always new and amazing features. Thank you for keeping us in the picture. (no pun intended)
Your pun is picture perfect : ) : )
Great new feature 👌 Thank u Mike for keeping us updates with all the latest and greatest 👍
You are welcome, Nader!!!!
This is a new Excel era!
Riiight!?!?!? Microsoft keeps giving us new eras like DATA Model and DAX, Power Query, Power BI, Dynamic Spilled Array Formulas and the new worksheet calculations engine, LET function, LAMBDA functions, Picture in Cell... They are very good to us : ) : ) : )
You are always my favourite teacher.
Picture in cell is fun.
Waiting to improve this feature to show in dropdown and powerquery.
Wow: that would be up to an even higher level: show in dropdown and Power Query : ) : )
Thanks for your kind words about my teaching! I love being on the Team with you too, Softwaretrain awesome teacher : )
@@excelisfun What softwaretrain said.
@@spilledgraphics Aahhh... geee golly... Thanks to you both for the kind words!!!!
Hi, Mike. Great video as always. This picture in cell is great even better is that you can use the cell as part of a formula. Excel just keeps getting better and better!
So true: better and better : ) : )
Finally I got my doubt cleared on entering a barcode of a product gives it respective image...
Let me tell you one thing
I have nearly 40-42k products and I need to arrange them and represent them by product category,weight,supplier and most importantly by amount....now I got the solution
You just ....just......just.....saved my life.....
Thnkssss....mike ...
Lucky to have a teacher like you...
One more thing to tell you...
Why dont you start a complete course of data science....it is my humble request you to look forward to it....
And again thankkkkkkkkkkkkkkkkkkkk.......you ❤❤❤❤❤❤❤❤
Hi Mike, saw a few videos of this new feature, and thought it just going to be very similar, but you blew this right out of the water. Never did I imagine doing lookups on the pictures.
Yah, new Neta features do not flow out to all beta subscribers at the same time. I got this feature a few weeks late... But I kept looking and today it popped up so I had to make a video. I never imagines either... : )
I have been taking advantage of your excel knowledge since 2010. Incredible.❤
Glad to help since 2010!!!!!
Amazing!!!
Yes!!!!!
Great feature 👍👍 and salute for your hard work 👏👏 because of your channel I have been becoming expert in excel.. You're my motivation 😊
Thank you so much for your videos 🙏
You are welcome so much!! I am happy to motivate you : )
Very useful Mike. Thanks. 👍
Always is glad to help!!!
Unbelievable, thanks Mike!!!
You are welcome, Chris M!!!!!
Mashaalla ! Super sir
Very nice class🎉
Glad you like it!!!!
That BAM! on minute 1:18 was soulful Mike! 🔥🔥🔥BAM!!🔥🔥🔥
WHAT!!!! spilled arrays with images?!?! minute 2:14 !!!
There are three BAMs in this video because I am just so bammingly amazed!!!
Riiiiiiiight!?!?! bammingly amazing!
Thanks Mike :)
You are welcome, Formula Guy!!!!
So clean! If I remember correctly in previous Excel versions, didn't we have to resize the cell to accommodate the image after inserting?
This is so awesome
Yes: Microsoft is very good to us : )
Awesome!
Great to hear from you, My Long Time Friend!!!!!
@@excelisfun Since YT turned e-mail notifications in 2020 I am missing a lot of your videos. Mobile notifications are useless, they just don't work for my "watching style". I used to have some e-mail notifications in my inbox and used to watch all videos in the evening when I have time to do it. After watching I used to delete those notifications. The lack of those notifications completely messed up my YT watching routine :/
@@pmsocho That is the same thing that happened to me. I get no more notifications. It really makes following difficult. That is what happens when RUclips and Google became a monopoly... : (
Great video!! ✌
The pictures act like any other values , copy, paste, paste as values, unique, all work even SORT does something (no operations, math or any kind work) .
The coolest part, they can be lookup values so this formula works fine. ( Sheet 1822 (an) ) Having only the picture can retrieve all the info.
=XLOOKUP(J5:J7,Pa[[#All],[Picture]],Pa[[#All],[Product]])
Will all the AI capabilities, soon enough, will be able to search using different pictures of same item. In Excel. 😉
Also these work, check them out:
=SUMIFS(Pa[Price],Pa[Picture],J5:J7) pictures as criteria
=MAP(J5:J7,LAMBDA(x,SUM((x=Pa[Picture])*Pa[Price])))
Another trick. A compromise solution until will have a ISPICTURE function. (like ISNUMBER, ISTEXT, ISLOGIC)
If we have a column vector that has mixed data and pictures, an easy way to filter only the pictures.
If we append empty string to any data type will get text (no error) , if we do it to a pic will get an #VALUE error.
Replace some of the pics in C5:C12 with some numeric or text values. To filter only the pictures:
=FILTER(Pa[Picture],ISERR(Pa[Picture]&""))
@@Excelambda SUMIFS!!! : ) : )
@@Excelambda Yes, filtering for only the pictures!!!! Thanks for all your wisdom, ExcelLambda : )
@@excelisfun SUMIFS for you, MAP for me...😂
Hey, Mike. I am planning on getting a new laptop since I’ve had mine for a while now. I was wondering if you had any recommendations. I’ve just started my excel journey and am planning to keep improving and learning as much as I can. I am planning on using this laptop for Microsoft Office, mainly Excel. Please let me know if you have any personal favorites or recommendations from your experience.
I am not a hardware guy. Not sure what is best. However, do not get a Mac. The Excel on a Mac is significantly different and employers want PC skills.
@@excelisfun I understand. What do you use personally?
😍👌
: ) : )
Mike, the file is currently unavailable! Thanks...
Sorry about that. I just fixed it. Be sure to clear browser with F5 before trying again.
BAM!!!
I think there were 3 BAMs!!! in this one lol
I want to insert pictures in cells but sorting them based on specific column which has the pictures names.
U understand me ?
I have a bingo game that I want to create with pictures. Is it possible to be able to randomly sort each column so that I can make 20 bingo cards for my classroom?
Here is a video I just made for you: ruclips.net/video/gW84oK2mpGw/видео.html But look at the pinned comment below the video, it has an even better formula.
@@excelisfun thank you so much for creating the video, I tried the formula, but it didn’t work. I’m assuming because the feature is in beta test. Is there a way for me to get this done?
@@lavelclaytorsProjectswPurpose You have to sign up for Microsoft Insider Edition. Just google it : )
Wow you can find a student's or person 's identity once you got his or Her picture through cctv in either college Record or National data base... is it so??
I am not sure.
I bought one of those boomerangs and the damn thing just came right back after I threw it.
Too funny hahahahah : ) : )
😅 👌 👍
: ) : ) : )
Looking up values by their associated picture came as something of a surprise! I wonder whether SORTBY does anything meaningful with pictures?
Oz did a video and sorted and he mentioned that it was odd because there was no indication of how it sorted.
😄 👌👍
🤯🤯🤯🤯🤯🤯🤯
: ) : ) : ) : ) : ) : ) : )