วีดีโอ

very good, thank you

SUPPER HELPFULL

Let me guess...you've been trying python in excel

Genius!!

I watch a lot of youtube videos for excel issues. Yours was one of best ones! Thank you!

Why did you have to use the CHOOSECOLS Function? Is it not possible to have FILTER(B1:C149,D1:D149=""Mouse")

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

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

Right what I needed ! Thanks a ton !💯

Great video, thanks!

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

goshh! thanks

Thanks

Thank you! Very helpful

THANKS !!!

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

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

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

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

Perfect!

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

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!

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

Very helpful, thanks for sharing

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

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

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

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

Thank you !

Thanks!

Hi Man, Thank you very much!

Thank you so much

OMG straigt to the point. Thank you!!!

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?

Amazing❤

Also TEXTJOIN is only supported on Excel 2019 and above.

Good explanation, just what I was looking for.

It misses a decimal point - is there a workaround?

Thank you, subscribed, turned on notifications and liked 👍

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.

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

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 ?

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

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!

What is the formula used in column B2

Can I fix colors to certain items in it ?

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))

Saved my life I was looking for this tut for hours

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

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 %