Пікірлер

• 
  @sujamenon93166 күн бұрын

  Right what I needed ! Thanks a ton !💯

• 
  @datauntelligence6 күн бұрын

  Excellent. Glad you stumbled across my little channel. Thanks for the comment

• 
  @iitomo08077 күн бұрын

  Great video, thanks!

• 
  @datauntelligence6 күн бұрын

  No probs. Thanks for the comment

• 
  @miniverma27688 күн бұрын

  How can we get the same type of result for more than one criteria like, Mints, bananas & Blueberry etc.

• 
  @haidzhaider784412 күн бұрын

  goshh! thanks

• 
  @datauntelligence12 күн бұрын

  Hey hey. No worries. Thanks for the comment

• 
  @suthirprabhu484515 күн бұрын

  Thanks

• 
  @datauntelligence15 күн бұрын

  No worries. Thanks for leaving a comment.

• 
  @alexandrashadae16 күн бұрын

  Thank you! Very helpful

• 
  @datauntelligence16 күн бұрын

  No probs. I'm happy I was able to help.

• 
  @deen9oh916 күн бұрын

  THANKS !!!

• 
  @datauntelligence16 күн бұрын

  No probs. I'm happy you liked it.

• 
  @jarlelidal53217 күн бұрын

  Hi, thanks for the video. It so happens that I need to find the "Mints" in several cells. Tried with this formula but got an error:: =IF(ERERROR(SEARCH(A3;'Sheet1'!I2:L2));"";"YES") How do I solve this? Thank you

• 
  @sner32318 күн бұрын

  mate your videos are great, i am having problems formulating some information, any chase you can help me?

• 
  @AccountsAsclepius24 күн бұрын

  in column E shows vertical results but when I tried it's not show in vertical can you resolve

• 
  @datauntelligence24 күн бұрын

  It is using 'spill' formula which isn't available in older versions of excel. Could this be the issue? Or maybe you have something in the cells below already?

• 
  @steves829226 күн бұрын

  Tried and tried and couldn't get it to work. Copied your work ver batin and no luck. What am I doing wrong?

• 
  @vernonsublett711726 күн бұрын

  Perfect!

• 
  @cmdramethyst.862526 күн бұрын

  This tutorial was, quite simply, *excellent*. Thank you so much ! =]

• 
  @davep.638528 күн бұрын

  Very helpful . Because of your tips, the last formula works on textbefore as well. I'm putting you on save as favorites file. Thank-you sir!

• 
  @datauntelligence28 күн бұрын

  Nice. Happy to hear you're also reworking a similar formula for your own needs. Thanks for commenting.

• 
  @thexrmanАй бұрын

  There is now a way to do this, you can use =textbefore(B2, " ").

• 
  @chrisgoes9610Ай бұрын

  Very helpful, thanks for sharing

• 
  @datauntelligenceАй бұрын

  No problem. This is a lot easier than the old index/match formula. Thanks for the comment.

• 
  @shqgeneralАй бұрын

  Hi, thank you very much for this great function , but plz how can i make data order by ascending

• 
  @datauntelligenceАй бұрын

  Hey there. Glad you're loving the formula. To take it to the next by sorting it, you would wrap the formula in a 'sort' function. For example, if the column you wanted to sort by is the 3rd column from the left, you would type =sort(originalformula,3,1). Here is a short video on the basics of the sort function. kzread.info/dash/bejne/a6it08erlM2eqLQ.htmlfeature=shared

• 
  @hamiltondencel4162Ай бұрын

  hello, i have a long text just example Deferred: As per technician pump send to shop for overhaul. ETC May 2025 (At shop) how to get (At shop) in excel? thank you

• 
  @mr.bipstv9264Ай бұрын

  Can you have more than 1 true value word in the formula

• 
  @datauntelligenceАй бұрын

  Hey there. It is a bit tricky, but you could 'nest' another (if) formula in the formula on the video.

• 
  @cacoduckАй бұрын

  Man thanks for keeping it concise and just showing what I clicked the video for. MASSIVE PROPS!

• 
  @datauntelligenceАй бұрын

  Thanks for the feedback, and I appreciate the comment. I try to keep my videos on point.

• 
  @DhirajWagh-jq9lvАй бұрын

  Thank you !

• 
  @datauntelligenceАй бұрын

  No problem. Thanks for enjoying and leaving a comment.

• 
  @AlejandroGonzalez-bj2ghАй бұрын

  Thanks!

• 
  @datauntelligenceАй бұрын

  Thanks legend, every bit helps my small channel. Glad the video was helpful.

• 
  @user-ot1iw1xc6uАй бұрын

  Hi Man, Thank you very much!

• 
  @datauntelligenceАй бұрын

  No probs. Hopefully it was useful. I like using this formula.

• 
  @contrastentertainment1749Ай бұрын

  Thank you so much

• 
  @datauntelligenceАй бұрын

  No problem. Thanks for leving a comment

• 
  @MK-tj2xuАй бұрын

  OMG straigt to the point. Thank you!!!

• 
  @davidbarrett1497Ай бұрын

  Thanks, very clear, what's the effect to the total Growth % number at the bottom of the table? As I understand it it will show a blank, how can you mitigate this?

• 
  @josephlesliekj9223Ай бұрын

  Amazing❤

• 
  @datauntelligenceАй бұрын

  Thanks for the comment. It's a simpe, but very useful formula

• 
  @abdolakbarpour5789Ай бұрын

  Also TEXTJOIN is only supported on Excel 2019 and above.

• 
  @NorthFloridaLivingАй бұрын

  Good explanation, just what I was looking for.

• 
  @datauntelligenceАй бұрын

  Thanks for leaving a comment. I try to make my videos short and to the point, so I'm happy it gave you what you need.

• 
  @RajshekherGarikapatiАй бұрын

  It misses a decimal point - is there a workaround?

• 
  @yahayarotimialawoki1256Ай бұрын

  Thank you, subscribed, turned on notifications and liked 👍

• 
  @datauntelligenceАй бұрын

  Thanks for the comment... and all the extras. :)

• 
  @ElectricLadyland872 ай бұрын

  Thanks for such a concise and effective video! I'm sort of new to actually making formulas and whatnot, it's always been a very mystical thing to my mind lol. This make's it a breeze.

• 
  @datauntelligence2 ай бұрын

  Thanks for the comment. Glad I was able to help. Let's hope there are many more formula to come for you.

• 
  @bellytripper-nh8oxАй бұрын

  ​@@datauntelligenceTHERE IS **NO** SUCH WORD AS **CONCATENATE**

• 
  @VongSamnangBou2 ай бұрын

  I think for the filter of non blank data, it should be A2:A1000 or similar as the total rows from Vstack combine may exceed 100

• 
  @datauntelligence2 ай бұрын

  Good advice. Thanks

• 
  @artemike2 ай бұрын

  how can i have more than one word in the "if contains example)? I am guessing you need to combine filtering word A, word B and the OR function somehow ? Like, in your example how can I filter results from two different states ?

• 
  @DavidBrown-nj6eb2 ай бұрын

  How do you scale this to numerous rows? I need to apply this to thousands of rows at a time.

• 
  @user-rr5dy9hk2k2 ай бұрын

  Could you please provide guidance on how to edit data within Excel filtered results? I'm interested in learning methods to manipulate and update data while working with filtered views in Excel. Any assistance or instructions you can offer would be greatly appreciated. Thank you!

• 
  @akkibaatality66312 ай бұрын

  What is the formula used in column B2

• 
  @firekeyur27542 ай бұрын

  Can I fix colors to certain items in it ?

• 
  @datauntelligence2 ай бұрын

  Hi there. It is possible to have dynamic colours, but it can be pretty complex. This video shows you how to do it using values, but it might give you an idea on how to solve your problem. kzread.info/dash/bejne/qq5ht9CpirLdhaw.html

• 
  @remarkable_ruin86082 ай бұрын

  When I try the last formula, it works until I try to add the second data set. After I close the formula, I get #VALUE. Not sure what I'm doing wrong but if it helps as all, here are the formulas I used . The one that works > =XLOOKUP([@[PART NO. COPY]],A2:A3,I2:I3) The one that doesn't work > =XLOOKUP([@[PART NO. COPY]],A2:A3,XLOOKUP([@[OP COPY]],B2:B3,I2:I3))

• 
  @chica1111chica2 ай бұрын

  Saved my life I was looking for this tut for hours

• 
  @datauntelligence2 ай бұрын

  Yes!! Glad you found my vid, and that it helped you out. I really like the filter function

• 
  @peterklemenc30942 ай бұрын

  I have been looking everywhere for a simple tutorial on this. And you explained it it 3 mins. Fantastic job.

• 
  @datauntelligence2 ай бұрын

  Great. I use this feature all the time. I'm happy this helped.

• 
  @KristenFarmer-cz8it2 ай бұрын

  I'm not sure what to do. I am using the filter function, I would like column D to return if the % is less than 85 during a specific shift (A,B,C,D). Shifts are labeled in a row above the %

• 
  @datauntelligence2 ай бұрын

  This might be difficult based on how the data is setup.

• 
  @Dexter101x2 ай бұрын

  I wish you would get rid of the music, a bit irritating and distracting

• 
  @datauntelligence2 ай бұрын

  Hey, thanks for the comment. Feedback noted, I was trying something new.

• 
  @danielhartjes24792 ай бұрын

  Great video and example. Thank you!

• 
  @datauntelligence2 ай бұрын

  No problem. Thanks for commenting. Xlookup is my favourite function.

• 
  @kirk19682 ай бұрын

  Very clear and helpful tutorial, nice work!

• 
  @datauntelligence2 ай бұрын

  Thanks for the feedback. It's surprising how often I need to use this formula.

• 
  @kirk19682 ай бұрын

  That is definitely a very useful one!

• 
  @riquelmeone2 ай бұрын

  Why would microsoft not just offer that as a default functionality rather than having to type that complicated function out? I can imagine this is a regularly required effort.

• 
  @datauntelligence2 ай бұрын

  Haha, yeah agree. This and many other formula.

• 
  @salimali23933 ай бұрын

  Thank you so much sir

• 
  @datauntelligence3 ай бұрын

  Thanks for the comment. Glad it helps my fellow Excel user.

• 
  @nancyspring-dc9rf3 ай бұрын

  This was awesome. Saved me so much time. Thank you!

• 
  @datauntelligence3 ай бұрын

  Yahoo... that's great to hear.

• 
  @mattdupuis98113 ай бұрын

  Excellent content! 🏆 This function is amazing! Is it possible to filter with only visible columns? I have an Excel table with slicers that I'm using as a dynamic tool and I would like to return the 10 lowest numbers (on a chosen column) for any filtered state that the table is in.

• 
  @johnhackwood15683 ай бұрын

  Fantastic practical real world example, thank you!

• 
  @datauntelligence3 ай бұрын

  Thanks for the comment. Glad you found it useful