DIFFERENT TYPES OF CELL REFERENCING IN EXCEL IN HINDI
ฝัง
- เผยแพร่เมื่อ 26 พ.ย. 2018
- A very warm welcome to all my viewers in EXCEL4LEARN Channel. Today I cover the defination of cell referencing and its types.
What is Cell Referencing?
A cell reference, or cell address, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.
Types of Cell Referencing:-
Relative cell references
Absolute cell references
Mixed cell references
TH-cam Playlist URL:-
• MS-Excel Tutorial by A...
LIKE,SUPPORT and SHARE
PLease press SUBSCRIBE Button and hit the bell icon for notification.
LIke my FB Page:- / excel4learn
Instagram Id:- akshay_d13
Google + :- plus.google.com/b/10259595250...
LinkedIn: / akshay-dey-028101138
#EXCEL4LEARN #CELL_REFERENCING #MS_EXCEL #excel_tutorial
You have helped me for this topic i will be grateful to you
Thankyou sir I can understand the concept just because of you
Thanks sir i m watching this one day before exam😅
Same brother 😓
I am before practical
Same here
Same bro😅
Me toooo
Thank you so much sir for this lovely explanation.....🙏🙏🙏🙏🙏
Excellent, Thanks
Bhut badhia bro jldi ni asan aur holi tarike se kar ke batya
Nice Explanation sir
Thankyou Sir for wonderful explanation
Iam just subscribe your channel
0:50 video start
Thank you. It was very helpful
Thanks sir it is very useful 👏👏👏👏👏
Helped a ton thanks 😊😊😊
Thank you sir😊😊
Thank you very much sir
So helpful!!
Finally this video helped me
Cudos 😊
Bahut shandar sir
Thnx sir 🙏🏻🙏🏻
Thank you so much sir 💞💞😊😊
Very good sir...❤️❤️🔥🎉😎🙏😀
not sir iam bro
Pankaj How many marks in exam?
Thanks
Thank you sir🥰🥰
I want a formula for variable cell reference.
I am having a row of 100 number A1 to A100.
I am having a other row of 100 numbers in column B1 to B100
Now in Column C, I want to average A1 to A100 based on value on column B1 to B100
Suppose if $A$1:A10 = 50, and at that time B10>0, now for next averaging I want to use formula $A$11:A12, $A$11:A13,$A$11:A14 and so on.
Again if anytime, say $A$11:A20 = 100 and same time B20>0, I want to change average formula from next cell and it will become $A$21:A22,$A$21:A23, $A$21:A24 and so on
Pls guide
Pls mail ur file.: akshaydey5@gmail.com
Thanks ❤
Actual Gigachads be like : 🍷🗿
Just 6 hour before my exam at 2 30 night
The right most cell in tow 32 in a worksheet
thx
Sir mujhe cell reference sikhna he ache se.plz help me
today is my exam and iam studying this at 5 :36 AM
Same
What
mine is tomorrow
@@meeshansoni1872 all the best 👍👍
It's 6:00 in the morning where I live
My exam is at 7:00
Thank you sir aapane mujhe fail hone se bacha diya 🎉😂😂
Isme absolute or mixed me difference pta chalega
Sir Tomorrow my practical for this topic
Sir mixed function ke liye ek video banaiye na sir jisme app book se padhana
Meanwhile me watching this 2 hours of exam😅
Hi
SEXY PDHAYA MJA AGYA PDH K THANK U SIR
Abhi 20 date ka subha ho gaya hai
Hlw, bro agar koi result bnate hai to ushme reference kaise karenge jaise ki agar90 se upar aaega to grade AA 80 na avobe hoga to A+ 25 aaya to pass aur25 ka niche aaya to fail ye apply kaise hoga
You can choose vlookup with approximate match or you can use if loop. I made same video please check my playlist.
Bhai or confuse kr diya tumne m
Not understood well
You should change chart first
Relative reference samajh nhi aaya
Need to improve explanation
Mera exam 20 ko hai
All the best..🙂🙂
Nd kal meri oral hai computer ki🖥🖥
Thanku sir🙏
Aap achhe se samaja nhi paa rhee
Thank you sir
Thanks
Thank you sir very much