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
fribbid fribbid yeah the mixed part is a little confusing. The example here is much clearer ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LFIykJmL4M8.html
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.