$D$6 locks the reference in all directions, i.e. if you pull up and down or left and right. $D6 locks in the left and right direction only. D$6 locks in the up and down direction. D6 is completely unlocked, or "relative referenced"
...your videos are the only ones I have enough patience to watch all through :) Could you please explain the differences between: =C9*$D$6 VS =C9*D$6 and VS =C9*$D6 (F4 ones, twice and 3times)
My professor linked your tutorials to our class portal and I must say that this video has been very insightful.
Mad teaching skills bro! If I weren't broke you'd be on the Christmas list, have a great one!
Thank you sir, glad I could help. Your kind reply is gift enough.
$D$6 locks the reference in all directions, i.e. if you pull up and down or left and right. $D6 locks in the left and right direction only. D$6 locks in the up and down direction. D6 is completely unlocked, or "relative referenced"
Very Clear. Thank you.
Great video again! Please do one on pivot tables.
Well done! Thanks so much!
...your videos are the only ones I have enough patience to watch all through :)
Could you please explain the differences between: =C9*$D$6 VS =C9*D$6 and VS =C9*$D6 (F4 ones, twice and 3times)
Hy Helen, I believe you must have gotten this answer already.
Is there a link where you can download your examples?
can i ask what is mixed reference?
very good
this was mentioned in my class, but I never got it, thanks