I stumbled into your video after watching 4 others and couldn't find my answer. And your explanation pinpointed the exact issue/solution I was looking for in a short few minutes. Thank you so much!!! Subscribed. Look forward to watching more of your videos.
Hi sir, your all videos are wonderful and very nice. Your speak is very clear and easy to understand. Thank you for your videos. It's very use full improve the skills.
Hi sir, your all classes of videos are very good. But not useful for beginners, only useful for professionals only. These classes are reminding the forgotten things for professionals in ms office, please make videos for beginners also to understand... Thank you.
I don't understand the concept of ctrl+shift+enter. Previous tables were also same and we used array function there as well but we didn't use ctrl+shift+enter, then why only here we need to use. please elaborate.
My guess, If more than one function is used you have to press ctrl ,shift and enter . It's like double pressing enter one for trim function and other for Vlook function.
Because of array function, we have to use Ctrl+shift+enter. Array functions mean you put a function eg. =SUM() with array of data Eg. A1:A8 and when you use that array function inside another function or another array function, you have to use Ctrl+Shift+Enter. Otherwise, it would display the wrong answer.
Sir this formula is applicable on the same sheet only where data and vlookup formula is available like you have done above is the data and below finding lookup value . Because i am trying it on different sheet like data is available on sheet 1 and finding lookup value on sheet 2 do not showing me the answer.
Sir.... The value is one time appear so...this type very useful... Incase some duplicate values input the sources... At the time how to find the both value in one formula????
Sir kya aap asi student fees table taiyar kr sakte h jisme Kisi student ki fees submit krte Jaye or uska total fees update hoti Jaye......means monthly cell nhi bnakar direct data feed kre or student ki fees update ho Jaye.......
DOUBT - What is the need to press Cntrl+Shift+Enter? If we are entering the function aptly then why do we need to avoid any error? Ideally, the error should not come if we have given correct function? Can Tutorials Point (India) Pvt. Ltd. or anyone master of excel helps me to understand this?
Sir good morning i have one doubt in vlookup for example one cell have same name and value is different . But vlookup only take first value sir. How to take rest of the value sir. Kindly give me details sir. Thanks
Hi , Your all the videos are excellent but i cant find the link to download the Excel file (used by you) . it would be helpful if you share the link too...thanks
Very nice sir. I am teacher and prepare students result in Ms excel sheet and prepare pdf by using mail merge, but i face 1 problem in mail merge is that, number of digits after decimal point in percentage in mail merge is greater than 4, so how to trim percentage in mail merge upto 2 digit after decimal point.
I have a sheet in which mobile number are of 10 digit. I use len function, it shows 11 digit. Somewhere it show 12 digit. It means there are leading spaces. When I use trim to remove spaces, space does not remove. Can i get your mail id to share sheet.
To Get Certification, Click Here: bit.ly/38Jyu3p
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
I stumbled into your video after watching 4 others and couldn't find my answer. And your explanation pinpointed the exact issue/solution I was looking for in a short few minutes. Thank you so much!!! Subscribed. Look forward to watching more of your videos.
I really like the way you explain. May god bless u with more wisdom
I should say thank you for ur tips it helps me to work fastly instead of wasting my time in trimmed excel sheet👍
Hi sir, your all videos are wonderful and very nice. Your speak is very clear and easy to understand. Thank you for your videos. It's very use full improve the skills.
He is very good in teaching thanks for the v lookup explanation in understanding way
Thank you so much , I learned too much with your videos. The most important thing the way you described, Amazing, Thumbs up
Now i feel like vlookup was not that hard after watching these few videos wow. nicely explained
You are awesome teacher....before your sessions i don't know about vlook up...thanks brilliant teaching way..easy to understand for any one...
REALLY APPRECIATE THE WONDERFUL EXPLANATION, AND THE CLARITY, THANKS A LOT.
thank you ,It's so simple and easy.I like your way of teaching.I would like to watch more of your videos.
Very good teaching skills, iam regularly see yor videos sir
Thank you Thank you .. You've just saved my task alhamdulillah :D
Hello sir... I did not get why we need to use ctrl+shift+enter to get the answer.. Can u please explain what do u mean by array function?
Hi sir, your all classes of videos are very good. But not useful for beginners, only useful for professionals only. These classes are reminding the forgotten things for professionals in ms office, please make videos for beginners also to understand... Thank you.
I like the way you get straight into the point
It is awesome, now satisfied with one more technique, great
Thank u 🙏🙏🙏🙏 sir like your video and good teacher.
Sir . Aap ka Excell Ka knowledge shandar h.......ydi student fees shhet aap tayar krna BTA de ....bhut achha Hoga.......or aap plz reply kre
You are the great sir 🙏 thank you so much for make such kind of videos ☺️
Excellent tip
Excellent explanation
I don't understand the concept of ctrl+shift+enter. Previous tables were also same and we used array function there as well but we didn't use ctrl+shift+enter, then why only here we need to use. please elaborate.
same question
Since it is an array formula, we have to put Ctrl+Shift+Enter, remember that😉
Y to use ctrl shift enter
My guess, If more than one function is used you have to press ctrl ,shift and enter . It's like double pressing enter one for trim function and other for Vlook function.
?
Excellent explanation in all you tutorials 👌
Very Nicely explained loved it 👏 👍
Thank you thank you thank you, this issue has been giving me a headache.
Is trim used for value as well as table simultaneously?
He is very good in teaching
Very nice videos Sir 👌
Why we need to press clt+shift+enter
Because of array function, we have to use Ctrl+shift+enter. Array functions mean you put a function eg. =SUM() with array of data Eg. A1:A8 and when you use that array function inside another function or another array function, you have to use Ctrl+Shift+Enter. Otherwise, it would display the wrong answer.
we learn a lot from your videos sir keep this working continue
Thanks for the session, Can trim be applied to both sets of data simultaneously ?
yess you can
Thanks a lot sir for your videos.
all your excel video are instruct in a good way...
Yes ,you teach very well to students
u can apply the range without pressing f4 so u can get the same answer right am i correect
Thanks was very Helpful
Sir you are doing very well and it is very useful for everyone but sir can you make videos of SAP Software
Y cntrl shift enter was not used for previous one
Very helpful lot of thanks
Tanku sir...this video helps to understand easily
Thank you😊😊😊😊😊😊
Thank you indeed 🙏
Is it a projector or large Monitor or what it is? In which he is touching?
U r awesome sir...so brilliant 👍
And can u explain where exactly the particular formula used.
Thank you so much sir, very nice
Very helpful, thank you very much
thanks your all video very useful .....
Hi. Thanks alot for this trim function with vlookup
superb and lucrative . Thanks
Sir ji you're great
is there any videos in the channel regarding SAP ...?
Thanks for the video.
Great Videos brooo
Sir, why did you press Ctrl+shift+enter?
Can you show the example where trim is required in both set of data, also how to find out which set out of data need trim formula.
Sir this formula is applicable on the same sheet only where data and vlookup formula is available like you have done above is the data and below finding lookup value . Because i am trying it on different sheet like data is available on sheet 1 and finding lookup value on sheet 2 do not showing me the answer.
why do we have to press ctrl+shift enter?
Why do you have to press ctrl+shift+enter ?
Very informative...
Sir.... The value is one time appear so...this type very useful... Incase some duplicate values input the sources... At the time how to find the both value in one formula????
ys sir.. please do the video for the same.
Sir kya aap asi student fees table taiyar kr sakte h jisme Kisi student ki fees submit krte Jaye or uska total fees update hoti Jaye......means monthly cell nhi bnakar direct data feed kre or student ki fees update ho Jaye.......
U r excellent sir
very nice class sir, thank you so much
Good presentation
DOUBT - What is the need to press Cntrl+Shift+Enter? If we are entering the function aptly then why do we need to avoid any error? Ideally, the error should not come if we have given correct function?
Can Tutorials Point (India) Pvt. Ltd. or anyone master of excel helps me to understand this?
i have the same doubt
Y u used F4 to fixed the data..?
If we want the data in another sheet then we don't have to use F4 r8..?
To fix the table ...yes if another sheet....its fixed by default
@@ramakrishnagunde9327 at 4 o'clock in morning u r replying me..! 🙄🙄
Am not in India... please
Thank you sir explanation was good
Great video
it will be good if you also provide the excel sheet for practice
In previous video u said VLOOKUP column can only be numbers ? Now here u r using text also ?
What is the reason to use Ctrl+shift+Enter.
Sir good morning i have one doubt in vlookup for example one cell have same name and value is different . But vlookup only take first value sir. How to take rest of the value sir. Kindly give me details sir. Thanks
U used table array in "Space in lookup value" example too but u didn't use ctrl+shift+enter there.
Because there was no function on Range
@@explorerhari thanks man!
Good job bro 🤗
Hi , Your all the videos are excellent but i cant find the link to download the Excel file (used by you) . it would be helpful if you share the link too...thanks
Lalwani 😇
Hi, it would be really helpful if you can provide explanation on the below queries because I too have a same doubts
Very nice sir.
I am teacher and prepare students result in Ms excel sheet and prepare pdf by using mail merge, but i face 1 problem in mail merge is that, number of digits after decimal point in percentage in mail merge is greater than 4, so how to trim percentage in mail merge upto 2 digit after decimal point.
hi sir, how will I come to know there is a space in my data or other? coz its not possible to check each ..
didn't knew about ctr+shift+enter.
Thank You.
The same ?????
I have a sheet in which mobile number are of 10 digit. I use len function, it shows 11 digit. Somewhere it show 12 digit. It means there are leading spaces. When I use trim to remove spaces, space does not remove. Can i get your mail id to share sheet.
How make vlookup from two different file?
Is there any alternate for ctrl+shift+enter ???
It's very good
Hi sir is it possible to share entire videos Excel sheets
Sir without using F4 key Results showing same( no difference) then why we want to use F4 key
hi bro, but why cntrl shft enter???
in my laptop f4 button is used to control brightness,it does't work for lock the cell, like $ sign..Anybody suggestion plz!!
in laptop a separate function key given for use with function with function keys that after it will work properly
Awesome
Running description is overlapping the bottom of the sheet making it invisible.
Thank you so much.
This video has so much twists than the Christopher nolan's movies
Use of ctrl+shift+enter?
How can we get the values divided by count in vlookup?
Why do we have to freeze the table using f4 in this case, please explain
To make it absolute , or lock it do that when you drag down it doesn't change
Why you use ctrl shift enter
I didn't get pls anyone clear it🤔
Instead of trimming, why cannot be do approximation search in VLOOKUP? Am I missing something?
fantastic videos but we was hope to put workbook to practices
Sir aapka data ki flie kaise mile gi pratice
Can anyone tell me the logic behind using crtl+shift+enter ?
he used to avoid error message
Awesome!