What to do when suppose if condition is true than we want to multiply some value and if false than want to multiply by other digits
@datauntelligence11 күн бұрын
Good question. In this case, replace "mints" with the true outcome you want... for example A2*15. Again for the result of false, place the formula in the space instead of "".
@jimstanley_4914 күн бұрын
For bonus points, calculate the total or average hours worked from A2 to Sunday.
@cherimaeeee1916 күн бұрын
does it work on Google Sheets? it had result on "ERROR, FILTER has mismatched range sizes. Expected row count: 998. column count: 1. Actual row count: 1, column count: 1."
@unvunb715718 күн бұрын
very good, thank you
@datauntelligence17 күн бұрын
No problem. Thanks for the comment. How often do you use excel?
@unvunb715716 күн бұрын
@@datauntelligence very often, but I have an older version which does not support "unique".
@datauntelligence16 күн бұрын
Ah yes, Excel seems to update often. It's hard to keep up with what's new.
@sner32318 күн бұрын
SUPPER HELPFULL
@datauntelligence18 күн бұрын
Great, thanks for the comment.
@Dexter101x19 күн бұрын
Let me guess...you've been trying python in excel
@datauntelligence19 күн бұрын
Yeah, python in excel is a good addition. Have you tried it? What do you think?
@Dexter101x19 күн бұрын
@@datauntelligence I’ve only tried the basic things at the moment. It’s slightly different from what I’m used to
@nsanerydah19 күн бұрын
Genius!!
@datauntelligence19 күн бұрын
Ha, thanks for the comment.
@LoveMyGarden1320 күн бұрын
I watch a lot of youtube videos for excel issues. Yours was one of best ones! Thank you!
@datauntelligence20 күн бұрын
Thanks for the top comment. Great to hear the videos have helped you out!
@stevereed577620 күн бұрын
Why did you have to use the CHOOSECOLS Function? Is it not possible to have FILTER(B1:C149,D1:D149=""Mouse")
@datauntelligence20 күн бұрын
I love mixing and matching formula to find a solution I need. Great advice though to make the function even shorter.
@micashand23 күн бұрын
Hello I have roster I need a formula I have this formula =count if(i8:i49,"E*") I did the removing E for EL but the first for E works but when I the and EL it doesn't pick up the shifts I put as EL I don't know how to adjust the formula to pick up all the shifts as EL but when use AND for awaking night the for waking nights it works? Is it because there E in both formula and it doesn't recognize the EL. It recognize it as E not EL by so doing giving me wrong data
@hadinaeem474123 күн бұрын
Hello, my work has a lot of compter generated data, that data is mostly divided in parts with inverted commas ("), how can i use them as delimiters? is there a way to use inverted comma itself as a delimiter
@datauntelligence23 күн бұрын
Hi there, this is a weird excel quirk, but if you want to use " as the delimiter, you need to enter " four times. So for example, if you wanted use the textafter function for text1"text2 in cell (a1) you would use =textafter(a1,"""") the result would be text2. Don't forget to like and subscribe 😀
@hadinaeem474123 күн бұрын
@@datauntelligence really appreciate the help Thanks
@sujamenon9316Ай бұрын
Right what I needed ! Thanks a ton !💯
@datauntelligenceАй бұрын
Excellent. Glad you stumbled across my little channel. Thanks for the comment
@iitomo0807Ай бұрын
Great video, thanks!
@datauntelligenceАй бұрын
No probs. Thanks for the comment
@miniverma2768Ай бұрын
How can we get the same type of result for more than one criteria like, Mints, bananas & Blueberry etc.
@haidzhaider7844Ай бұрын
goshh! thanks
@datauntelligenceАй бұрын
Hey hey. No worries. Thanks for the comment
@suthirprabhu4845Ай бұрын
Thanks
@datauntelligenceАй бұрын
No worries. Thanks for leaving a comment.
@alexandrashadaeАй бұрын
Thank you! Very helpful
@datauntelligenceАй бұрын
No probs. I'm happy I was able to help.
@deen9oh9Ай бұрын
THANKS !!!
@datauntelligenceАй бұрын
No probs. I'm happy you liked it.
@jarlelidal532Ай бұрын
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
@sner323Ай бұрын
mate your videos are great, i am having problems formulating some information, any chase you can help me?
@AccountsAsclepiusАй бұрын
in column E shows vertical results but when I tried it's not show in vertical can you resolve
@datauntelligenceАй бұрын
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?
@steves8292Ай бұрын
Tried and tried and couldn't get it to work. Copied your work ver batin and no luck. What am I doing wrong?
@vernonsublett7117Ай бұрын
Perfect!
@cmdramethyst.8625Ай бұрын
This tutorial was, quite simply, *excellent*. Thank you so much ! =]
@davep.6385Ай бұрын
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!
@datauntelligenceАй бұрын
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, " ").
@chrisgoes96102 ай бұрын
Very helpful, thanks for sharing
@datauntelligence2 ай бұрын
No problem. This is a lot easier than the old index/match formula. Thanks for the comment.
@shqgeneral2 ай бұрын
Hi, thank you very much for this great function , but plz how can i make data order by ascending
@datauntelligence2 ай бұрын
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. kzbin.info/www/bejne/b6Xcopiomc9rrrMfeature=shared
@hamiltondencel41622 ай бұрын
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.bipstv92642 ай бұрын
Can you have more than 1 true value word in the formula
@datauntelligence2 ай бұрын
Hey there. It is a bit tricky, but you could 'nest' another (if) formula in the formula on the video.
@cacoduck2 ай бұрын
Man thanks for keeping it concise and just showing what I clicked the video for. MASSIVE PROPS!
@datauntelligence2 ай бұрын
Thanks for the feedback, and I appreciate the comment. I try to keep my videos on point.
@DhirajWagh-jq9lv2 ай бұрын
Thank you !
@datauntelligence2 ай бұрын
No problem. Thanks for enjoying and leaving a comment.
@AlejandroGonzalez-bj2gh2 ай бұрын
Thanks!
@datauntelligence2 ай бұрын
Thanks legend, every bit helps my small channel. Glad the video was helpful.
@user-ot1iw1xc6u2 ай бұрын
Hi Man, Thank you very much!
@datauntelligence2 ай бұрын
No probs. Hopefully it was useful. I like using this formula.
@contrastentertainment17492 ай бұрын
Thank you so much
@datauntelligence2 ай бұрын
No problem. Thanks for leving a comment
@MK-tj2xu2 ай бұрын
OMG straigt to the point. Thank you!!!
@davidbarrett14972 ай бұрын
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?
@josephlesliekj92232 ай бұрын
Amazing❤
@datauntelligence2 ай бұрын
Thanks for the comment. It's a simpe, but very useful formula
@abdolakbarpour57892 ай бұрын
Also TEXTJOIN is only supported on Excel 2019 and above.
@NorthFloridaLiving2 ай бұрын
Good explanation, just what I was looking for.
@datauntelligence2 ай бұрын
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.
@RajshekherGarikapati2 ай бұрын
It misses a decimal point - is there a workaround?
@yahayarotimialawoki12562 ай бұрын
Thank you, subscribed, turned on notifications and liked 👍
@datauntelligence2 ай бұрын
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-nh8ox2 ай бұрын
@@datauntelligenceTHERE IS **NO** SUCH WORD AS **CONCATENATE**
@VongSamnangBou3 ай бұрын
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
@datauntelligence3 ай бұрын
Good advice. Thanks
@artemike3 ай бұрын
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-nj6eb3 ай бұрын
How do you scale this to numerous rows? I need to apply this to thousands of rows at a time.
@user-rr5dy9hk2k3 ай бұрын
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!