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
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
Thank you for the video! I understand mixed referencing now.
I Lol'd at 'Delicious Nachos' . Perfect Timing, and excellent comedic delivery ! :)
thank you so much for youre well explained and heldpful content
Thank you! Now I understand mixed,absolute and mixed cell references
Wow I got it all so easily thanks.
Yes very helpful, theoretically it can't be understood
Did it today in class but didn't understand it thank you so much for your help still need more practice
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 th-cam.com/video/LFIykJmL4M8/w-d-xo.html
Yea he's good
Thank you so much!
Best explanation so far🎉
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
This video helped me a lot!!!!!
Thank you sir.
Thanks sir you are the best
Thank you a lot.
Thank u Daniel Sir
Got it thank you .
Great explanation
Very informative...
Thank you for sharing. I need to watch this a few times and get it memorized!!
THANKS
Thank you
Good explanation
Thanks a lot sir
Excellent
I just came cause my assignment is about this Thanks though.
EXECELLENT
mixed cell reference :(
Thankd a lot i got it
Oh
I also
I've got absolute and relative cell referencing but not the mixed ! :(
The mixed cell reference is not much clear
Did not got the mixed cell referencing
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
I do not get it... :'( :'( :'(
replay the video
0
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
Lol mixed cell referencing is so useless
literally what the fuck
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()