Thanks for sharing this video to us sir. due to some illness i couldn't go school for few days and i couldn't go with computer bcx I'm rlly weak in it but sir this video has encouraged me and helped me a lot to do in computer now waiting for the computer exam and results of it....i understood relative and absolute cell reference but not mixed reference but its okay thank u sir i smashed the like button and subscribe button
To folks who are a bit confused, Columns are called by letters , rows are called by numbers and now try to rewatch the video and get some better clarity without being confused
I want a formula for variable cell reference. I am having a Column A of 100 number 1 to 100. I am having a Column B of 100 numbers 0 to 100 Now in Column C, I want to average Cell value of A1 to A100 based on value on column B1 to B100 Suppose in Column C ,if Average of $A$1:A10 = 50, and at that time B10>0, now for next averaging in Cell C11 I want to use formula $A$11:A11, $A$11:A12,$A$11:A13 and so on. Again if anytime in Column C, say $A$11:A20 = 100 and same time B20>0, I want to change average formula in Cell C21 from next cell and it will become $A$21:A21,$A$21:A22, $A$21:A23 and so on Pls guide
You might want to show the formula bar to show how each formula will change for each set of values. Your effort, although appreciated, was a waste of your time and the viewers.
Simple & clear. Gun point explanation! Thank you!
Thanks for sharing this video to us sir.
due to some illness i couldn't go school for few days and i couldn't go with computer bcx I'm rlly weak in it
but sir this video has encouraged me and helped me a lot to do in computer now waiting for the computer exam and results of it....i understood relative and absolute cell reference but not mixed reference but its okay thank u sir
i smashed the like button and subscribe button
I Lol'd at 'Delicious Nachos' . Perfect Timing, and excellent comedic delivery ! :)
You had me until the mixed cell referencing part. Im still trying to get it. Overall its the best explanation I've seen thus far.
Yeah mixed is a bit confuzing
fribbid fribbid yeah the mixed part is a little confusing. The example here is much clearer czcams.com/video/LFIykJmL4M8/video.html
Yea he's good
thank you so much for youre well explained and heldpful content
Great informational video. I'm taking an online class and got stuck on absolute referencing, this video helped me understand it and do it correctly!!
Uhhh
Best explanation so far🎉
Thank you! Now I understand mixed,absolute and mixed cell references
This video helped me a lot!!!!!
Very informative...
Good explanation
To folks who are a bit confused, Columns are called by letters , rows are called by numbers and now try to rewatch the video and get some better clarity without being confused
Yes very helpful, theoretically it can't be understood
Great explanation
Thank you for the video! I understand mixed referencing now.
Thank you for sharing. I need to watch this a few times and get it memorized!!
Did it today in class but didn't understand it thank you so much for your help still need more practice
Thanks a lot sir
Got it thank you .
Thank you a lot.
Thank you
Wow I got it all so easily thanks.
THANKS
I've got absolute and relative cell referencing but not the mixed ! :(
The mixed cell reference is not much clear
Excellent
Thank you sir.
Thanks sir you are the best
I just came cause my assignment is about this Thanks though.
Thank u Daniel Sir
Thank you so much!
mixed cell reference :(
When I press Enter after writing formula using absolute cell reference, the answer is #value! why I can't get correct answer? sir, Plz reply.
Put = sign
Did not got the mixed cell referencing
Thankd a lot i got it
Oh
I also
I do not get it... :'( :'( :'(
replay the video
EXECELLENT
I want a formula for variable cell reference.
I am having a Column A of 100 number 1 to 100.
I am having a Column B of 100 numbers 0 to 100
Now in Column C, I want to average Cell value of A1 to A100 based on value on column B1 to B100
Suppose in Column C ,if Average of $A$1:A10 = 50, and at that time B10>0, now for next averaging in Cell C11 I want to use formula $A$11:A11, $A$11:A12,$A$11:A13 and so on.
Again if anytime in Column C, say $A$11:A20 = 100 and same time B20>0, I want to change average formula in Cell C21 from next cell and it will become $A$21:A21,$A$21:A22, $A$21:A23 and so on
Pls guide
You might want to show the formula bar to show how each formula will change for each set of values. Your effort, although appreciated, was a waste of your time and the viewers.
=FORMULATXT()
Lol mixed cell referencing is so useless
0
literally what the fuck