No video
Why Excel BEATS Google Sheets with THESE 10 Features!
Рет қаралды 60,644
Күн бұрынJoin 400,000+ professionals in our courses here 👉 link.xelplus.c...
In this video we'll explore 10 features of Excel where Google Sheets doesn’t compete (yet).
This is also a quick tutorial about Excel's best features. It's filled with Excel tips. Did you know all of them?
This covers the Excel Vs Google Sheets debate. Whereas in the previous video we looked at Google Sheets vs Excel. Check it out here in case you missed it: • Google Sheets BEATS Ex...
With Google Sheets becoming a popular alternative to Excel, it’s important to recognize the strengths and weaknesses of each application. This also gives you an idea of what Sheets and Excel are used for and are capable of.
LINKS to related XLOOKUP videos:
• How to Use the NEW & I...
• How to do a Left Looku...
• Discover What XLOOKUP ...
Power Query: • How Power Query Will C...
Check Out the Complete Excel Power Query course: courses.xelplu...
⯆ Check out the complete blog post about Excel vs. Google Sheets: www.xelplus.co...
★ My Online Excel Courses ► www.xelplus.co...
00:00 Microsoft Excel versus Google Sheets
00:33 XLOOKUP
01:53 Excel Tables
03:30 Power Query
04:17 3D Formulas
05:36 Flash Fill
06:38 Excel's Data Model
07:44 Hash References for Dynamic Ranges
10:03 Charts with Conditional Formatting
12:06 Go To Special
13:17 Set Print Area
14:22 Pivot Slicers and Linked Shapes
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
@LeilaGharani 3 жыл бұрын
Looking forward to chatting tomorrow when this premiers. In case you haven't watched the previous video, watch it before this one: kzfaq.info/get/bejne/pJh0q7uXy7jccoE.html. Curious which application will be the winner for YOU.
@haashini10031985 3 жыл бұрын
It's Always Excel. Google sheets were not user-friendly to use comparing to Excel. It's like Even though IPhone Might makes us curious, but not user-friendly and most like Android!
@IbadassI 3 жыл бұрын
Excellent video. Can you do one where Excel or sheets connect to MSSQL or other databases with realtime updating? Or non realtime if realtime is not possible? Many thanks.
@chrisheringer905 3 жыл бұрын
@LeilaGharani - do you know, if all things are equal, does using a table format increase file size? I work in huge files, and try to shave off file size wherever I can. So, assuming 2 files, same data in both files.... 1 is formatted as a Table, the other is a Range. Should these files be the same sizes?
@GiuseppeGaetanoSabatelli 3 жыл бұрын
Google Sheets has "Image in Cell." So freaking useful for pumping out visual reports, signage, POPs, promotional material, etc.
@DavidMulderOne 3 жыл бұрын
Love the tables, had no idea, just wanted to note that in Google Sheets you can "D2:D" to select the entire column without needing to type it out. Still nowhere near as clean as the Excel tables, but worth knowing maybe
@TylerStanczak 3 жыл бұрын
Excel is insanely powerful and I love how you demonstrate this in such a cool way. Again amazing thumbnails as always :)
@LeilaGharani 3 жыл бұрын
Glad you think so! 😁
@emmanuelonuoha3642 2 жыл бұрын
Where have you been all my excel life. Thanks for giving me wings.
@mondaymendoza1239 3 жыл бұрын
As an hr practitioner who needs to do employee profiling, one of the most important features for me is the image lookup which i've tried so hard to do in excel but i just failed. Now that i've learned that g sheets has that image lookup (thanks to ms. Leila's channel), i think i'd transfer my data to g sheets, especially that i needed others to help me with the file now. i'd like the xlookup, format as table and set print area for g shheets too so that my experience will be completely satisfying
@LeilaGharani 3 жыл бұрын
Sounds great!
@captainkeyboard1007 3 жыл бұрын
Your series on the features of Microsoft Excel and how it differs from Google Sheets was excellent and well presented.
@momocorolise9915 3 жыл бұрын
I'm so glad that I found your channel 2 years ago. In this 2 years, I've learned so much from all of your videos. I can say that I started with 0 in excel, but now I'm a data analysis! That makes you also a great teacher. (Sorry for my bad English, buy yeah, you know what I mean). 😉
@LeilaGharani 3 жыл бұрын
Wow, thank you!
@nsanwal 3 жыл бұрын
@@LeilaGharani I agree, you are amazing Leila, I learned all from your video only. Thank you so much..
@excelisfun 3 жыл бұрын
Cool series, Leila!!!!!!!
@LeilaGharani 3 жыл бұрын
Thanks Mike!
@SMARTproAcademy 3 жыл бұрын
THANKS, Ienjoy these two videos, really interesting,I always wondered the differences between one and the other
@LeilaGharani 3 жыл бұрын
Glad you like them!
@SeamusHarper1234 3 жыл бұрын
In short: It's better in any way that matters if you want to do serious work / data wrangling. Excel is a much deeper rabbit hole.
@ThepExcel 3 жыл бұрын
For me, the best of Excel features (comparing with Google sheets) is Power Query!
@LeilaGharani 3 жыл бұрын
True, Power Query is great!
@ricos1497 3 жыл бұрын
Great video. Obviously Power Query and Power Pivot are quite key. It would have been interesting to see a comparison in how you could get data from an external source in Sheets vs Excel to illustrate this difference though. For example, how would you go about extracting data from a series of text files in Sheets for use in a pivot table with an element of relationship modelling. Whether there is anything even close to a substitute in Sheets.
@haashini10031985 3 жыл бұрын
@ Leila - 3D Formulas and Hash References are Leila's Highlights in this video. All other options looks normal. But, understood that it relates to Heading! Thanx for Sharing.
@AlThePal78 3 жыл бұрын
Power Query really is the best highlight and if you learn it you will be able to see that its so powerful
@benhaze1010 3 жыл бұрын
You are indeed the Excel Wonder Woman Leila! Thank you for making these comparisons. One comment I would add is the serious Google Sheets limitation with the maximum number of cells of a worksheet and the long processing time when working with a 15-20 Mb file. For example Google Sheets is not able to handle analyzing work orders with tens of thousands lines of labor and parts costs which is not an uncommon feast for a medium size service company. There is no debate for a Power User which is the better application as shown by your demonstrations.
@leostar1100 3 жыл бұрын
You are the best ! Your teaching skills are more powerful than these excellent excel tools.
@LeilaGharani 3 жыл бұрын
Wow, thanks!
@rashtonc.mtombeni3755 3 жыл бұрын
I love your videos Leila, and thanks for the comparison. The contest though is an unfair one because you compare Google Sheets that runs online versus a fully featured Excel. A fair boxing match would have been Google Sheets versus Excel Online. My thoughts.
@frost_inc 2 жыл бұрын
One more point in MS Excel's favour: Excel doesn't use floating point math (as long as I've noticed), which is something that Google Sheets does. Had to learn about this "feature" the hard way. :D
@Marcel-qb9ge 3 жыл бұрын
Xlookup seem interesting, but whenever I need to look for data on the right-hand side of the index, I just create a range with the {} operator =Vlookup(A2, {Table!E:E,Table!A:A }, 2, 0)
@donald-parker 2 жыл бұрын
A great pair of videos! I hope the product managers of both Excel and Sheets watch these.
@discovermore1 3 жыл бұрын
Great information, as usual... always same expectations and same result got from your side...Thanks
@goblin003 2 жыл бұрын
I selected Excel over Sheets specifically for the column (horizontal) sort function, it is absent from Sheets. My application is an oddity in that it has a crucial visual component that relies on column reordering. But bravo to Sheets for bringing competition back to the spreadsheet arena.
@ManafKAMIL 3 жыл бұрын
This is a really, REALLY useful video... thank you 👍👍👍
@LeilaGharani 3 жыл бұрын
Glad it was helpful!
@moi984 3 жыл бұрын
A big fan for long!! Your way of explaining and showing examples are super. Also the title pictures of your video's are very clear and handy! Many greetings from Amsterdam!!!
@mickthunder1107 3 жыл бұрын
I love your efforts on not only sharing knowledge free of charge(which is amazing, and I wholeheartedly appreciate you for that) but you also upped your thumbnail game! LOVE IT! keep up the amazing work, and I truly thank you for your time and effort for preparing these incredible videos.
@zubairso 3 жыл бұрын
This was super comprehensive and really amazing. I think I am going to stick to excel for now. Plus can't wait for your course on DAX/Excel data modelling. Loved the Power Query course.
@TheOrionMusicNetwork 3 жыл бұрын
Same. The power query course has been life changing.
@LeilaGharani 3 жыл бұрын
Awesome, thank you!
@StevenWan11 3 жыл бұрын
The fill blanks example at 12:40 needs more attention... great trick!
@Morphineck 3 жыл бұрын
Great video. I think that the overall vba(script)/macro functionality is miles ahead in excel (buttons, shortcuts, custom menus, references in vba).
@helenwelsh967 3 жыл бұрын
Once again, a great video. I didn't know about GO TO SPECIAL. I have spent so much time dragging down values from spreadsheets which are set up in groupings. This is a great Tip!!
@LeilaGharani 3 жыл бұрын
Glad it was helpful!
@doktorexcel8603 3 жыл бұрын
I have been working with Excel for a while now but I am always surprised how little I know. Thanks for the video. As always just great.
@LeilaGharani 3 жыл бұрын
Great to hear!
@tedsterrett7204 3 жыл бұрын
The amazing Leila, your skills are incredible! take care.
@williamkiarie 3 жыл бұрын
The ability to link a number to a shape is great!
@chrism9037 3 жыл бұрын
Very comprehensive Leila! Great video. Excel is the winner in my book. PQ puts it over the top
@LeilaGharani 3 жыл бұрын
Power Query is hard to beat :)
@abelnyamori 3 жыл бұрын
As always, these videos are insanely well done. Very insightful and the explanations are clear enough for a commoner like me to understand. I just learned how to solve a problem I didn't know I had until I saw the Hash section. Amazing
@LeilaGharani 3 жыл бұрын
Much appreciated!
@Derivatives_Hunter 3 жыл бұрын
You are awesome ma’am... excellent teacher 👍🙏
@karl_m3013 3 жыл бұрын
Long-time Watcher, first time commenter. You forgot muscle memory. I have 25 years of using Excel. Every time I go to Sheets I am so much slower with everything. A couple of years ago sitting with a client, who grew up using Sheetes, building a spreadsheet and they could not believe how quickly I could build a spreadsheet.
@LeilaGharani 3 жыл бұрын
Good point, thanks Karl.
@karl_m3013 3 жыл бұрын
@@LeilaGharani Leila. I thought I was a SS expert as I had been using them since 1980 with VISICALC on an Apple then Lotus 1-2-3 on a PC and then Excel since the early 90's. I actually worked for both Lotus and Microsoft in management from the late 80's and 90's and I passed the Excel certification testing that MS had at the time. Since 2000, I have built lots of spreadsheets for my companies and others. Then I started watching your videos and realized I had missed many, many amazing features. We did a study at Lotus and discovered that average users only used 5-10% of the available features. I never thought I would would fall into that category. But I did over time. Yes I used multi nested if statements and pivot tables. but I had got lazy. I started watching your videos when I had a complex table based SS to build and I learned so much very quickly and easily. Your style is great. You are my go to when I want to learn a new feature. Thanks for making these videos accessible to everyone. Cheers...K
@shakiraasfoor7599 3 жыл бұрын
Well Done,, google sheet have also flash fill
@TheNabob57 3 жыл бұрын
You in a superheroine's outfit. How fitting! I enjoy your videos... you have excellent diction and are very informative.
@2JSinc 3 жыл бұрын
You are a real life Superhero...
@mirrrvelll5164 3 жыл бұрын
Overall, Excel on the top but "sheets" should be also in a toolbar for quick access and solving some "ad-hoc" things when necessary. I am sure on long term "sheets" will be as good as Excel.
@katrinabryce 3 жыл бұрын
Set Print Area has been in Excel since at least v4 in 1992. I don't remember it in v2 (1987) and I never used v3. I am amazed that Google Sheets doesn't have it.
@LeilaGharani 3 жыл бұрын
Me too Katrina :)
@wayneedmondson1065 3 жыл бұрын
Hi Leila. Great summary of 10 superior EXCEL features. Thanks for sharing them :)) Thumbs up!!
@markpodesta4605 3 жыл бұрын
Thank you Leila. Excel is much better than Google Sheets!
@nassimabed 3 жыл бұрын
Excel never ceases to amaze
@TiagoFreire 3 жыл бұрын
I think it would be cool if you compared Power Query with Google Query Language in a dedicated video just for the topic. While they are syntacticallty different, they perform similar roles. Google`s Importrange() references other sheets, while power query can reference other documents in different sources as well. Google Sheets have permalinks, even if the file moves or is renamed, the formulas will not break (this is important)
@vijayarjunwadkar 3 жыл бұрын
OOPs, missed the premier as I got late, but no regret! 😁 Watched it again all over and it's 10/10 for the 10 features of Excel you explained in that "Leila Style" we have come to love! Cheers! 😊👍
@LeilaGharani 3 жыл бұрын
Glad you enjoyed it!
@Uz4L 3 жыл бұрын
Please do Numbers vs Excel, I have MacBook Pro but never used Numbers
@chuchuokeke 3 жыл бұрын
The amount of work put into these videos is a lot. This was highly edutaining. Thanks! Choice of super heroes is meh though. Jean gray for excel and hawk girl for sheets is more like it...for me Wait you know VBA? Small wonder you can simplify many of these features. You were born to teach!
@LeilaGharani 3 жыл бұрын
Much appreciated!
@user-eb9hk9mr3t 3 жыл бұрын
i will follow your videos thank you so much
@nassimabed 3 жыл бұрын
The question is, who will be faster to upgrade and include the other features? Microsoft or Google?
@SoulTrain101 3 жыл бұрын
I'd put my money on Google sheets. They've been adding new capability weekly. Excel is famous for very old errors that have never been fixed.
@mondaymendoza1239 3 жыл бұрын
I hope it's google because they're free to use and i hope it continues to be free. HAHAH
@mondaymendoza1239 3 жыл бұрын
I'd really love to have that program where all of the advantages of g sheets and excel is fused into one
@Henry_Nunez 3 жыл бұрын
Very good video. Gracias amiga. Saludos desde Venezuela.
@tubeampsrule1 2 жыл бұрын
Sounds like the best choice is using both! Sheets for the things excel can't do. Pull that in with PQ and enjoy the rest of the day!
@LeilaGharani 2 жыл бұрын
That's a good plan 😁
@mohamed.montaser 3 жыл бұрын
the way to write spilled ranges or hash reference like you said in the video in google sheets is to drop the range reference at the end like instead of writing a2:c10 you can do =ArrayFormula(A2:C) , its pretty old in google sheets , i don't know how u didn't find out about it.
@LeilaGharani 3 жыл бұрын
I use that, but that's not spilled ranges like in Excel. They include any other data that might be on that column. Spilled ranges are restricted to the specified range but they grow as the range grows. They don't include data from other tables that might be below the first one.
@osamasaid8476 3 жыл бұрын
god bless you . thanks a lot
@krn14242 3 жыл бұрын
Thanks Leila, great comparison. Sticking with Excel...
@Rahul_Seth 3 жыл бұрын
05:36 Flash Fill Very nice example
@cesarprieto395 3 жыл бұрын
The winner is... Leila!! Thanks for sharing your knowledge 👍🏻 I thought I’d see something about VBA in here 🤔
@LeilaGharani 3 жыл бұрын
Thanks 😊 I left out VBA because in sheets you also have macros (apps script based on Javascript)
@cesarprieto395 3 жыл бұрын
Leila Gharani thanks for your reply 😁😁! I didn’t know about that, does it include user forms too? I guess excel still has the advantage because we have your VBA course to help us learn 😉
@LeilaGharani 3 жыл бұрын
But soon I'll launch my Google Sheets course 😉
@nonoobott8602 3 жыл бұрын
Wow. I love your explanations. Thanks for sharing
@LeilaGharani 3 жыл бұрын
My pleasure!
@AJ-et3vf Жыл бұрын
awesome video! Thank you!
@LeilaGharani Жыл бұрын
Glad you liked it!
@lpanebr 3 жыл бұрын
I wish Google sheets team sees your comparison videos and make it better! Thanks!
@surajnirankari7623 3 жыл бұрын
Even without watching i know its a great video with amazing content.
@LeilaGharani 3 жыл бұрын
Wow, thanks!
@surajnirankari7623 3 жыл бұрын
@@LeilaGharani we shall be thankful to you for all your videos.
@rocket3704 3 жыл бұрын
XLOOKUP() is cool, but Google sheets lets you create on-the-fly arrays in curly brackets so you can use VLOOKUP() and order the columns any way you need within your array brackets.
@70pjsmith 3 жыл бұрын
Another great video Leila, thank you. I eagerly look forward to Microsoft making Power Query available to Mac users (hopefully soon!).
@LeilaGharani 3 жыл бұрын
I hope so too!
@chibigon01 3 жыл бұрын
You forgot to compare the "Goal Seek" function and the "Solver" Add-in in both applications (very important Excel functions in engineering). I have a question for you: is it possible to use LaTex code to type text inside a cell in Excel or Sheets? Thank you very much for your videos, they are very helpful.
@angelgarcia7152 3 жыл бұрын
OpenSolver is much better than Excel native Solver cause it's not limited.
@imramugh 3 жыл бұрын
Thank you for another awesome video. I learned so much.
@LeilaGharani 3 жыл бұрын
You are so welcome!
@excellerhaiti 3 жыл бұрын
Thanks so much !
@assem8858 3 жыл бұрын
I like your way of teaching, do you have any power query video on excel for mac ?
@LeilaGharani 3 жыл бұрын
Unfortunately, there really isn't much Power Query functionality in Excel for Mac (yet).
@M.A.Sammani 3 жыл бұрын
Now it's so fair, honestly, I was upset with the previous video when Google Sheets beat Excel. Thank you Leila.
@deependragupta7679 3 жыл бұрын
Queen of excel with another great comparison between google sheet and excel... I know excel is way better then google sheets.
@craigk621 3 жыл бұрын
Hopefully the costumes will see the light of day at least once a year for an update!
@ersins.1941 3 жыл бұрын
I think one of the biggest pluses for Excel is being able to edit multiple tabs at once where you cannot do that on Sheets without a code.
@aliikhlaq 3 жыл бұрын
You are the best on all KZfaq
@LeilaGharani 3 жыл бұрын
Wow, thanks Ali!
@ExcelWithChris 3 жыл бұрын
Power Query and Data Models makes it so much more superior to Sheets. Once an Excel fan, ALWAYS one!
@israelhernandez1299 3 жыл бұрын
En espera del video, gracias por compartir!! 👍
@giuseppedonato5677 3 жыл бұрын
I was missing two fuctions: 3D Formulas and Hash References. The first one, probably, because I have never had a use case. The second one, because my italian enterprise 360 version doesn't have it (like xlookup and other new functions that I know thanks to your videos XD ). And this lead me to another point in favor of google sheets: just one version, global upgrades release, and so on. Anyway, pros and cons of both. Depends on the purpose, e.g. now I want to try sync Google Calendar with Google Sheets. I still keep thinking that Excel is generally better than sheets, but it is even much older. Sheets, otherwise, is not a mere copy of Excel like others (has google's touch) and it has great potential Awesome video :) keep it up :D
@LeilaGharani 3 жыл бұрын
Thanks for your feedback Giuseppe!
@kid123ik90ol 3 жыл бұрын
power query and power pivot are superior, so im sticking to excel
@montecristobal 3 жыл бұрын
Great videos. About feature number one, Google Sheets has DGET function, wich do the same and more than XLOOKUP, because is able to work with arrays.
@AjayKumar-fd9mv 3 жыл бұрын
Thanks
@peterzurowski2086 3 жыл бұрын
Great as always! Thanks Leila!
@LeilaGharani 3 жыл бұрын
Glad you liked it, Peter!
@RealForturama 3 жыл бұрын
Awesome Video as usual! Is it possible to colorize cells with comments automatically? "Go To Special" is awesome but this step needs to be repeated in order to be up-to-date. I can't find a conditional formatting for this task.
@sdsa007 3 жыл бұрын
Im ready to launch for both google and microsoft data-space missions... thanks mission control!
@maxhugen 3 жыл бұрын
CRITICAL issue with Google Sheets: script runtime is limited to 360 secs. I don't know if Excel 365 has similar "quotas", but with script that must use a lot of iteration (loops), this time limit can be a problem!
@johnglatt3627 3 жыл бұрын
This was AMAZING!!
@stephenong4545 3 жыл бұрын
would love to see a jupyter notebook vs excel breakdown
@jnhnmk 3 жыл бұрын
Can you help how to compere program language evolution using excel chart please
@joannadaanton2483 3 жыл бұрын
Yes, Excel is impressive in many ways. The features that were presented here are the ones that are really useful especially in data arrangements. The fact that Google Sheet is a web-based app makes it more of an app than a stand-alone software. While Excel can work with or without internet.
@monte4955 3 жыл бұрын
My usual Thursday night excel date with Leila. Great video as always. Shall we do it again next week? 😁
@LeilaGharani 3 жыл бұрын
Definitely!! :)
@aleb8243 3 жыл бұрын
...aaand the number one - pressing Enter to Paste
@darkshinigami9438 3 жыл бұрын
I love the Wonder Woman cosplay ❤️❤️❤️
@LeilaGharani 3 жыл бұрын
😊
@CarlosJimenez-yr1fh 3 жыл бұрын
You always get that tiny bit that changes the whole Excel experience. Vote for LG, forget Pedro.
@ajitkrtiwari2778 3 жыл бұрын
Hi! Can you plz make a video related to manage personal finance in excel?
@jtabeto 3 жыл бұрын
Hi Leila, I've learned a lot from you. Thank you for providing these videos. I have a question regarding Go to Special. If I want to select all blanks in a column but copy the values below each blank cell, what should I do? Thank you very much!
@LeilaGharani 3 жыл бұрын
It helps to use a helper column. Check if the cell on the same row is empty and with an IF get the value of the next cell.
@esbi1124 3 жыл бұрын
Hi, there. It was super. Many thanks.
@charlytovitruj7988 3 жыл бұрын
Congratulations very good video 😚
@LeilaGharani 3 жыл бұрын
Thank you! Cheers!
@GeertDelmulle 3 жыл бұрын
Nice video! I hope the critics will be nice on you. :-)
@LeilaGharani 3 жыл бұрын
I hope so too 😁
@dmstrat Жыл бұрын
As much as I like all the features of Excel, it just IS NOT natively online still. Want a combo-data graph, download to your desktop and create it, sync it back online, and now it is there. Want to change it, download it your desktop app and make the changes reuploading again. Want to connect that graph to a powerpoint slide? download BOTH files create the linked object and reupload, but the Powerpoint won't update if you update Excel workbook until, you guessed it, download BOTH FILES and update the links and upload again. Even if you use the msgraph connector it does NOT work. Even the object links between Excel and Powerpoint aren't reliable that they will update correctly between downloads and excel updates. Cool features. Too bad they don't work online. Oh, and you want to update Excel using MSGraph, can't automate it because I can't get a services account so now I have to watch what used to be automated so I can click on my ID when it pops up trying to get the auth token. So, something I could completely automate and run on a schedule without my attention now requires me to click my name 1/2 dozen times to finish all the updates. In Google Sheets and Slides, make everything and link everything ONLINE. Make a change using google APIs in Sheets? you can go to your slides and click the "update" button that now shows and you're updated. There's probably an API call to do that, but since we HAD to quit Google Apps, I never discovered it. So, while Google Sheets/slides may not have every feature Excel has built over the last 30+ years in the market, EVERY feature of sheets/slides works ONLINE.
@AlThePal78 3 жыл бұрын
What a great video and I know your an excel master but do you see yourself converting or just using both of them equally?
@venkatiyer7459 3 жыл бұрын
Yes my Ctrl+g [Go to Special] figured in your list ...An awesome one in excel .... I am referring both your videos to my friends .... as usual you are too good in your lectures .... thanks
@cdrosero 3 жыл бұрын
I always used F5 and Alt+S or click on Special.
@OzduSoleilDATA 3 жыл бұрын
You hit all the good ones! XLOOKUP, Data Models, Power Query. Excel is the tool for adults who work with data. 🔥🔥🔥
@LeilaGharani 3 жыл бұрын
😁
@silm632 3 жыл бұрын
Hello Leila! thank you for your amazing videos! i have a question regarding IF formula and i cant find it anywhere, if i want to look for a single word in a column (not per cell) and if it is true "A", false "B". i am trying with =IF(ISNUMBER(SEARCH("TEA",A5:A30)),"A","B") But is always showing me "B" because the word "TEA" is only in cell A5. Please help ? Basically i need to know if 1 single word shows in ANY of the multiple cells (each cell have also few words) and if it does i need the word "A"
ТВ3 - сериалы и шоу
Рет қаралды 2,6 МЛН
Coding with Dee
Рет қаралды 1 М.