Cell Referencing in Excel (When to add a $ in a cell)

[@KenjiExplains]

🚀Get the FREE Graph Templates from Hubspot: clickhubspot.com/t55

[@mohsinashfaq101]

At this point,I am just waiting for ONE TINY formatting video from our boi,
You taught me more than I could have ever imagined.

[@giorgimodebadze1869]

It now turns out that actually using $ sign into the formula is easy. Thanks, this was the best explain I've ever seen

[@charlestoneoyoo]

Great explanation, I loved how you explained the mixed cell referencing 🎉

[@lichunhwang6707]

Was confused about where to put the dollar sign when I was watching your tutorial before, finally got the point of this locking function, just need more practice, big thanks!

[@KenjiExplains]

Glad I could help!

[@willzinner8813]

best tutorila on this i've seen thank you

[@KenjiExplains]

Glad you think so! I appreciate it :)

[@JoseAntonioMorato]

Although not everyone has MS365, the future of Excel is dynamic arrays that do not require references:
1: =E3:E8*B3
2: =G3:G8*B3:D3
3: =C6:C9*D5:G5
4: =IF(C5:C15>F5,C5:C15*F8,"")
5: =INDEX(C9:G19,XMATCH(B4:B6,B9:B19),XMATCH(C3:D3,C9:G9)) 🤗

[@tomjun8945]

Your videos are amazing and so clear to follow. I learned a lot from your contents and helped me with my job everyday. Thank you !!

[@s2r2420]

Thanks a lot bro. I thought I knew some excel. But this beats me. So nicely explained. As you said in the beginning, I wish these were there earlier. Anyway, thanks for exposing this now

[@antoniop.3586]

Very clear. Finally, I understood it. Thank you very much Kenji!

[@roberth.9558]

Great presentation and instruction. Thank you.

[@wallywechs4694]

Wow, I like your tutorial sir, thumbs up

[@AnthonyOssai-xv1uy]

This was very helpful, thank you

[@camlex6310]

Really insightful!! Thank you!!

[@samratdey85]

After successfully passing the HR round of my recent interview, I faced a technical round where I was given several Excel exercises. Unfortunately, I struggled there because I got confused with the formulas. Is there a way to determine which formula to use in a problem statement in Excel to avoid such confusion in the future?

[@LivingGuy484]

You just have to learn what commonly used formulas do. There's no magic shortcut to knowing the answer when excel formulas address a large variety of problems.

[@NaveenKumar-sf5tx]

Thanks alot love from India
I am your student from India

[@silvestrecamposano6317]

The best formulas.. Thank you!..

[@NeagVasileNV-P]

Really useful! Thank you! 🤩But what if the data is contained in a table? How to reference in this case?

[@JustReadTheQuran]

Thank you. I learnt something...

[@serbonkers4130]

Salamat

[@RealSubs-ji8if]

I spend over 1 hour in your channel, good job.

[@Goddibaba]

Nice one, bro

[@SPYROS4KX]

Thanks! Please do a video for the MO-201 exam.

[@Dexter101x]

Nice one Kenji

[@waynez8136]

For challenge 5, can I use the nested xlookup functions to replace index(match)?

[@mayankchheda311]

Bro i love your videos...❤

[@KenjiExplains]

Thank you!

[@Wanaw-i7y]

Thank u so much

[@duncsindevon]

xlookup as opposed to index,match may be better

[@cigstarkyt9719]

Thanks!!!

[@Techeyeforthepeople]

Thank you sir. Nagode(means thank-you in Hausa Nigeria 🇳🇬)

[@KenjiExplains]

Awesome thanks for watching!

[@ofumekelvin9607]

Nice 👏👏👍👍

[@petecullan3113]

Thanks. But how does this work with tables with a named header? That’s where I struggle.

[@ABhiJain_1]

Sir please upload one data analytics and data cleaning playlist

[@Rimonvai-k8e]

this video seen complete

[@UtkarshKumar-mp2ls]

As usual 🎉

[@KenjiExplains]

Thank you for watching :)

[@echodelta7680]

Prefixing '$' before a number means only columns will change.
Prefixing '$' before a letter means only rows will change.
Prefixing both letter and number with '$' completely locks cell's value.

[@montebont]

Typical needlessly complicated "accounting" approach...Just add filters to the original table...all the info is already there...

[@mustakmnm7]

thanks alot 🫡

[@KenjiExplains]

thank you!