5 ай бұрын
5 ай бұрын
5 ай бұрын
6 ай бұрын
6 ай бұрын
6 ай бұрын
10 ай бұрын
10 ай бұрын
11 ай бұрын
Жыл бұрын
2 жыл бұрын
Пікірлер
@grantrizmo2002cb Күн бұрын
Total clickbait...video is 2 mins 15 seconds...😊
@datauntelligence Күн бұрын
Haha, You got me!
@empireambience2529 5 күн бұрын
Is there a version of this for Sheets in Chrome?
@alirehman4041 7 күн бұрын
Exactly what I was looking for
@datauntelligence 7 күн бұрын
Nice. I'm glad you found my video.
@RekhaDevi-rc3sn 11 күн бұрын
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
@datauntelligence 11 күн бұрын
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_49 14 күн бұрын
For bonus points, calculate the total or average hours worked from A2 to Sunday.
@cherimaeeee19 16 күн бұрын
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."
@unvunb7157 18 күн бұрын
very good, thank you
@datauntelligence 17 күн бұрын
No problem. Thanks for the comment. How often do you use excel?
@unvunb7157 16 күн бұрын
@@datauntelligence very often, but I have an older version which does not support "unique".
@datauntelligence 16 күн бұрын
Ah yes, Excel seems to update often. It's hard to keep up with what's new.
@sner323 18 күн бұрын
SUPPER HELPFULL
@datauntelligence 18 күн бұрын
Great, thanks for the comment.
@Dexter101x 19 күн бұрын
Let me guess...you've been trying python in excel
@datauntelligence 19 күн бұрын
Yeah, python in excel is a good addition. Have you tried it? What do you think?
@Dexter101x 19 күн бұрын
@@datauntelligence I’ve only tried the basic things at the moment. It’s slightly different from what I’m used to
@nsanerydah 19 күн бұрын
Genius!!
@datauntelligence 19 күн бұрын
Ha, thanks for the comment.
@LoveMyGarden13 20 күн бұрын
I watch a lot of youtube videos for excel issues. Yours was one of best ones! Thank you!
@datauntelligence 20 күн бұрын
Thanks for the top comment. Great to hear the videos have helped you out!
@stevereed5776 20 күн бұрын
Why did you have to use the CHOOSECOLS Function? Is it not possible to have FILTER(B1:C149,D1:D149=""Mouse")
@datauntelligence 20 күн бұрын
I love mixing and matching formula to find a solution I need. Great advice though to make the function even shorter.
@micashand 23 күн бұрын
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
@hadinaeem4741 23 күн бұрын
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
@datauntelligence 23 күн бұрын
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 😀
@hadinaeem4741 23 күн бұрын
@@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, " ").
@chrisgoes9610 2 ай бұрын
Very helpful, thanks for sharing
@datauntelligence 2 ай бұрын
No problem. This is a lot easier than the old index/match formula. Thanks for the comment.
@shqgeneral 2 ай бұрын
Hi, thank you very much for this great function , but plz how can i make data order by ascending
@datauntelligence 2 ай бұрын
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
@hamiltondencel4162 2 ай бұрын
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 2 ай бұрын
Can you have more than 1 true value word in the formula
@datauntelligence 2 ай бұрын
Hey there. It is a bit tricky, but you could 'nest' another (if) formula in the formula on the video.
@cacoduck 2 ай бұрын
Man thanks for keeping it concise and just showing what I clicked the video for. MASSIVE PROPS!
@datauntelligence 2 ай бұрын
Thanks for the feedback, and I appreciate the comment. I try to keep my videos on point.
@DhirajWagh-jq9lv 2 ай бұрын
Thank you !
@datauntelligence 2 ай бұрын
No problem. Thanks for enjoying and leaving a comment.
@AlejandroGonzalez-bj2gh 2 ай бұрын
Thanks!
@datauntelligence 2 ай бұрын
Thanks legend, every bit helps my small channel. Glad the video was helpful.
@user-ot1iw1xc6u 2 ай бұрын
Hi Man, Thank you very much!
@datauntelligence 2 ай бұрын
No probs. Hopefully it was useful. I like using this formula.
@contrastentertainment1749 2 ай бұрын
Thank you so much
@datauntelligence 2 ай бұрын
No problem. Thanks for leving a comment
@MK-tj2xu 2 ай бұрын
OMG straigt to the point. Thank you!!!
@davidbarrett1497 2 ай бұрын
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 2 ай бұрын
Amazing❤
@datauntelligence 2 ай бұрын
Thanks for the comment. It's a simpe, but very useful formula
@abdolakbarpour5789 2 ай бұрын
Also TEXTJOIN is only supported on Excel 2019 and above.
@NorthFloridaLiving 2 ай бұрын
Good explanation, just what I was looking for.
@datauntelligence 2 ай бұрын
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 2 ай бұрын
It misses a decimal point - is there a workaround?
@yahayarotimialawoki1256 2 ай бұрын
Thank you, subscribed, turned on notifications and liked 👍
@datauntelligence 2 ай бұрын
Thanks for the comment... and all the extras. :)
@ElectricLadyland87 2 ай бұрын
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.
@datauntelligence 2 ай бұрын
Thanks for the comment. Glad I was able to help. Let's hope there are many more formula to come for you.
@bellytripper-nh8ox 2 ай бұрын
@@datauntelligenceTHERE IS **NO** SUCH WORD AS **CONCATENATE**
@VongSamnangBou 3 ай бұрын
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
@datauntelligence 3 ай бұрын
Good advice. Thanks
@artemike 3 ай бұрын
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-nj6eb 3 ай бұрын
How do you scale this to numerous rows? I need to apply this to thousands of rows at a time.
@user-rr5dy9hk2k 3 ай бұрын
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!