DIFFERENT TYPES OF CELL REFERENCING IN EXCEL IN HINDI
HTML-код
- Опубликовано: 20 авг 2024
- 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
RUclips 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.co...
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
Excellent, Thanks
Thank you so much sir for this lovely explanation.....🙏🙏🙏🙏🙏
Sir Tomorrow my practical for this topic
Iam just subscribe your channel
Bhut badhia bro jldi ni asan aur holi tarike se kar ke batya
0:50 video start
Nice Explanation sir
Thank you sir😊😊
Thanks sir it is very useful 👏👏👏👏👏
Thank you very much sir
Actual Gigachads be like : 🍷🗿
Very good sir...❤️❤️🔥🎉😎🙏😀
not sir iam bro
Pankaj How many marks in exam?
Thankyou Sir for wonderful explanation
Finally this video helped me
Cudos 😊
Thank you. It was very helpful
Thnx sir 🙏🏻🙏🏻
Thanks
Bahut shandar sir
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 so much sir 💞💞😊😊
So helpful!!
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
Helped a ton thanks 😊😊😊
Sir mixed function ke liye ek video banaiye na sir jisme app book se padhana
Thanks ❤
Thank you sir🥰🥰
Just 6 hour before my exam at 2 30 night
The right most cell in tow 32 in a worksheet
Thank you sir aapane mujhe fail hone se bacha diya 🎉😂😂
thx
Sir mujhe cell reference sikhna he ache se.plz help me
Isme absolute or mixed me difference pta chalega
Meanwhile me watching this 2 hours of exam😅
Relative reference samajh nhi aaya
Hi
Not understood well
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.
SEXY PDHAYA MJA AGYA PDH K THANK U SIR
Abhi 20 date ka subha ho gaya hai
Bhai or confuse kr diya tumne m
Need to improve explanation
You should change chart first
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