Anna when i took data in bulk from last year to this year the date formate is incorrect means last year date formate is like 1-2-2018 this year formate is like 2/02/2019 when i put filter its showing incorrect formate how to correct that in right formate plz help me
Sometimes vlookup formula is not working in excel sheet. Do I have to change column format like, text, number, etc? Sometimes it is working without any problem. What mistake I do
sir drop down list is easy while in this vedio can you help to teach suggestion list while typing the first ONE or TWO or THREE letters in the cells and suggestion showing option
Anna create one playlist in English also because I'm not able to share with my frnds as they don't knw tamil and reason behind asking you is that no such playlist is good in my perspective so kindly requesting you yo create one🙏🙏🙏
Sir, ipo entire column kum Namma data validation panna drop-down list varanum nah enna pannanum, entire column nah select pannitha akanuma,???ila vera option Iruka...pls help me sir..next one cell values la kodutha name ah delete pannanumna epdi?
Hi sir, Nan, Price &Qty ya =ran bet()Formula use pani poten, But Nan total Podumpothu =sum if () formula use panen finala enaku qty automatic ah change aguthu sir. What is the problem happen here sir.
Anna when i took data in bulk from last year to this year the date formate is incorrect means last year date formate is like 1-2-2018 this year formate is like 2/02/2019 when i put filter its showing incorrect formate how to correct that in right formate plz help me
send your format
VLOOKUP(look,table,2,0) here i couldn't understand how the 0 comes. Can u tell bro? Anyone else?.
Sir, if error la , 0 pathila empty a varanum ,athu epdinu sollunga
Yaru thala ne..semma tutorial
Your all videos super
IN CASE 100 PRODUCTS AVAILABLE HOW TO SELECT IF ANY SEARCH BOX POSIBLE PLEASE REPLY
Very useful. Thank you so much 🥰
Sometimes vlookup formula is not working in excel sheet. Do I have to change column format like, text, number, etc? Sometimes it is working without any problem. What mistake I do
View this video's Vlookup In Excel Tamil: th-cam.com/play/PL4unWLKFsZfdkQcWWwPfUv71CXKh1QJBH.html
how to be use a stock maintain in a stores.......purchase & sale ,debit & credit pathi sollunga sir
I try it it throw error like #spill , what the problem sir.
Could you please also add a scenario where Approximate Match would be used
SIR, how did you created that template? from existing form or can we use blank sheet and type ourself?
According to vlookup day 9 video
Sir ,one doubt how 2,0 comes first column s.no, 2nd column item,3rd column rate so it comes 3,0 only
mugesh nsrgm enakum athey doubt than. Stanley Sir plz comment
You have to count from the columns you have selected. Not all the columns
sir drop down list is easy while in this vedio
can you help to teach suggestion list while typing the first ONE or TWO or THREE letters in the cells and suggestion showing option
Sure I will do
@@tutorjoes thanks
super bro . your teaching is easy
How to do date wise sales
Anna create one playlist in English also because I'm not able to share with my frnds as they don't knw tamil and reason behind asking you is that no such playlist is good in my perspective so kindly requesting you yo create one🙏🙏🙏
Super sir data multiple sheet connection link functions and pivot table link data functions konjam teach pannuinga sir please please please sir
Bill podumbothey innoru sheet la date oda bill amt save aganum ..... panna mudiuma sir
Sir, ipo entire column kum Namma data validation panna drop-down list varanum nah enna pannanum, entire column nah select pannitha akanuma,???ila vera option Iruka...pls help me sir..next one cell values la kodutha name ah delete pannanumna epdi?
Hi sir, Nan, Price &Qty ya =ran bet()Formula use pani poten,
But Nan total Podumpothu =sum if () formula use panen
finala enaku qty automatic ah change aguthu sir.
What is the problem happen here sir.
Superb... Boss 🙏
super thalaiva
Thanks lot sir, very usefull for my job !!!🙏🙏🙏
Bro, How to create "unique id" like roll no. from Excel data? Because ippo unique no's illama irukka excel file la yepdi vlookup achieve panrathu?
Thanks
Super very useful
Thanks 👍
NA very much useful, thanks a lot
CELL
I have one doubt. In my same product but price will be change on daily wise so you have any idea.
I have multiple tax rates how to set ..
how to be use a stock maintain in a stores.......purchase & sale ,debit & credit pathi sollunga sir
Hello sir good evening I don't know how to clear the items,look,pass and table names in the name box so could you please tell me sir
Thank you sir. Your teaching is awesome
Ithula sgst cgst and offers athula ebdi podrathu sir
For your referenceth-cam.com/video/HWoeyVGHWy8/w-d-xo.html
Nice video. Watching one by one.Sir can you pls share practice sheet .
Thanks a lot sir..
By using vlookup we can avoid retyping.. it is interesting
Thank You
Circular reference error varuthu bro enna pandrathu
Very helpfull video. Thanks a lot
You are Welcome
Ennoda job ku indha vedio useful aa irundhadhu.thank you bro
Dropdown List Tamil font eappade use pandrathu sir
In 2m 34 sec Alt + Down Arrow List out Drop Down
And your classes very helpful to me
sir ur each and every clasd is very very useful thank you so much.....and please upload source code of school manajement stytem project plzzzzzzzzz
You can download
github.com/TutorJoes-Stanley/School-Management-System-Project.git
Super bro... Please explain about Xlookup function
Still I didn't get excel update I will so soon
One workbook la vera vera sheet la irukura data ku missing data eapdi find panalam sir
Finding missing values
th-cam.com/video/0tuAYvrbkn4/w-d-xo.html
Sir,how to remove #ref error.please upload a video of type of errors in excel and how to fix it
user this formula
th-cam.com/video/j6ETkXyYZqM/w-d-xo.html
பயனுள்ள தகவல் நன்றி
Your way of teaching is ver appreciable
Weekly course bootstrap latest version tutorial upload pannuga sir plz...
Sure We will Upload it Soon
Bro (e-library) PHP project madiri ennoru project podunga waiting bro...
Sure
Clear explanations
Very useful bro..
how to add new itam
Line by line I am following your speech very clear Thank you sir...
You are Welcome
Explain Hlookup
BEST TEACHER
Thank you sir...
Thanks Sir
Thank you
Nice work...
Sooper sir
Thank you
You are Welcome
Nice one .
Thank You
Thanks jee
You are Welcome
Thanz sir
You are Welcome
Well sir easy to understand thank u 🙏🙏