Can you make a video how to copy and paste data without go to hiden row ?

But when i need slisers?

This formula can make a mess if the data is not uniform, let say asset number with description in a cell in 😢thousands and hundred thousand, here this formula will be lost

Thanks Sir 👍🏻👍🏻

no one zooms the screen , plz do it , thnks

Super helpful feature!!

Ctrl +E also do some magic splitting

I was expecting to see a scenario where rows were not just different but also rearranged. so i was thinking of concatenating all columns in a row then lookup from both sides

you put 13 number in 5th formula. and also in 4th formula you use 16. number. between the formal. not clarified actual what it is.

Thank you ❤️

Bruh, use sort(unique), then sum if. Done.

I am on a Mac, when I try this Excel prints the invoice and doesn't save the invoice. Any suggestions? Here is the code I'm using: path = "Volumes/Invoices/" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, ignoreprintareas:=False, FileName:=path & fname

Osu!!! master! Bow!

On what bases is the progress scoreed on?

Please the link to download Sql is not here.

Hi sir

No bro, this idea didn't work

@KenjiExplains HELP! I do not have the ability to select "FILTER" in insert a function. I only have "FILTERXML" available. What can I do to solve this?

How about the reverse, copy one cell and paste in to some rows

how can i activate my data types option on my excel ribbon

nicely explained.... cleared the basics....

That 'Spreadsheet Compare' bonus feature was DOPE!!!! Thanks Kenji

unable to find "=sequence" command.

These people live their lives and youths like they have a few to spare.

Hi. Good Instructions. Is there any option to be able to edit data from the search result ? or to highlight the findings on table itself ?

Brilliant. Loved it

Thank you Kenji for a wonderful tutorial. Just a quick question under Dietary Restrictions: When I inserted the Formula in case the Answer is a "Yes", if one opts for a "No", then it also indicates a "False" just below it. How do I correct that please?

Thank you

You can also access clipboard by pressing windows + V

Awesome! Thank you.

👍👍👍👍👍👍

I really enjoyed this lecture, even though short. Great job done by Kenji!

If the tax rate is not the same each year, then the WACC is also not the same year, is it?

If the tax rate is different each year, when calculating the WACC, which tax rate does it take? Can there be multiple WACCs based on the year?

Please reply which free version of Excel is best for partice professional level

thank you very good

Very informative. Thanks.

Very nice information and teaching sir.. from India North East

Nice interpretation

A simple VBA comparing cells is much easier.

What a ripoff. The downloaded file doesn't even include the search bar.

This was just the use of DAX functions. It's basic, but not fundamental.

This is not working working for me

Hii Kenji can make series on CRM or anyone can tell me who can teach CRM like Kenji i need urgent help 😢

why i can't download the excel file?

You just made my job 10x easier, thanks!! Subscribed

why groupby is not showing in my excel?

Definitely gonna go with the "2nd" and the "last" method. 😅😂

I have better way to check and reconcile both sheet diff