Відео

Nice one. Thanks for the comment.

Great to hear this was helpful.. Thanks for the feedback.

Thanks for the comment and feedback. I use these all the time.

Data set sir

Hi there, thanks for watching. I have a video that shows how to do a reverse concatenate. Check it out. ua-cam.com/video/AI6Bvqx5DE8/v-deo.html

So glad to hear that the video helped. Thanks for taking the time to write a message.

Wow, thanks for the awesome feedback. Happy you found this solution!

Ha, im happy you found my video.

Hi there, thanks for watching the video. Yes, excel automatically counts a value of zero, or blank, as the date 0/01/1900. So when you are dragging the formula down it is adding 120 months to that date and giving you a value. A way around this is to nest the formula in an IF formula... If the value is 'blank', then return nothing, otherwise complete the formula. This might work for you. =IF(J7="","",DATE(YEAR(J7),MONTH(J7)+120,DAY(J7))). Let me know if it works for you?

That's awesome to hear! I really like using pivot tables. Thanks for leaving a comment.

Hey hey. Take a look at this video, that shows you how to filter across multiple sheets. You could use the contains formula as part of this. ua-cam.com/video/Au-j0ytEqF4/v-deo.html

@@datauntelligence Thanks, I did look at that video, but I can't get the two to work together. This is what I tried: =FILTER(VSTACK(sheet1:Sheet2!A4:E200),(VSTACK(sheet1:Sheet2!E4:E200)<>""))*(VSTACK(sheet1:Sheet2!A4:E200,ISNUMBER(SEARCH(E1,E4:E300)),"No entries")) OR =FILTER(VSTACK(sheet1:Sheet2!A4:E200),(VSTACK(sheet1:Sheet2!E4:E200)<>""))*(A4:E200,ISNUMBER(SEARCH(E1,E4:E300)),"No entries"). But neither worked!

Ah ha, yes. That would be good. You must use spreadsheets a lot?! I would do this by adding in some 'conditional formatting' based on another cell. You can format cells (shade/color) based on another cell, or a reference cell. This video shows shows you how to do it based on numbers, but you can change it to reference a cell with text. Maybe it will give you some ideas. ua-cam.com/video/uWwAbFd2Ms8/v-deo.html

Yeah, I agree. I use this formula all the time. Thanks for the comment, it's great to see that it has helped you out.

might be easier if we jump on a zoom so i can show you

Hi, yes you certainly can. This video shows you how to combine multiple 'and' 'or' filter conditions. You can apply the same principle to filter contains and does not contain combinations. ua-cam.com/video/EXF1ewsrGfU/v-deo.html

Hey, yes that formula is only available in newer versions of Excel. I do have another video to get the last word with older editions of Excel. Try this out. What do you think? ua-cam.com/video/qAIgilKXaAk/v-deo.html

Haha, no problem. I try to keep my videos to the point. Thanks for noticing

No problem. Do you use charts often in Excel?

No pronblem. Thanks for the comment. Do you use pivot tables often?

Nice one! Keep going.

Hi. Glad you found the video. Pivot tables are great once you learn more about them.

Hey, thanks for the comment

That's great. Hopefully it came in handy. Unfortunately there isn't currently a way that automatically brings over the format from the original tables your filtering. You may need to format the destination cells before or after the combined file. If there is anyone else out there with a solution, let us know?!

Hi there. You can go to about 5:30 in the video. It shows you how to add 2 conditions. In your case, just include 1 condition where age>50.

Haha, You got me!

Nice. I'm glad you found my video.

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 "".

No problem. Thanks for the comment. How often do you use excel?

@@datauntelligence very often, but I have an older version which does not support "unique".

Ah yes, Excel seems to update often. It's hard to keep up with what's new.

Great, thanks for the comment.

Yeah, python in excel is a good addition. Have you tried it? What do you think?

@@datauntelligence I’ve only tried the basic things at the moment. It’s slightly different from what I’m used to

Ha, thanks for the comment.

Thanks for the top comment. Great to hear the videos have helped you out!

I love mixing and matching formula to find a solution I need. Great advice though to make the function even shorter.

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 😀

@@datauntelligence really appreciate the help Thanks

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

No probs. Thanks for the comment