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
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.
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?
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 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
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
Ennoda job ku indha vedio useful aa irundhadhu.thank you bro
Thanks lot sir, very usefull for my job !!!🙏🙏🙏
Your way of teaching is ver appreciable
Line by line I am following your speech very clear Thank you sir...
You are Welcome
Yaru thala ne..semma tutorial
super bro . your teaching is easy
Thank you sir. Your teaching is awesome
And your classes very helpful to me
Nice video. Watching one by one.Sir can you pls share practice sheet .
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
By using vlookup we can avoid retyping.. it is interesting
Thank You
Your all videos super
BEST TEACHER
Very useful. Thank you so much 🥰
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
Very helpfull video. Thanks a lot
You are Welcome
Super bro... Please explain about Xlookup function
Still I didn't get excel update I will so soon
பயனுள்ள தகவல் நன்றி
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.
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 ..
Superb... Boss 🙏
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?
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🙏🙏🙏
NA very much useful, thanks a lot
super thalaiva
Very useful bro..
Super very useful
Super sir data multiple sheet connection link functions and pivot table link data functions konjam teach pannuinga sir please please please sir
SIR, how did you created that template? from existing form or can we use blank sheet and type ourself?
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
Well sir easy to understand thank u 🙏🙏
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?
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
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
IN CASE 100 PRODUCTS AVAILABLE HOW TO SELECT IF ANY SEARCH BOX POSIBLE PLEASE REPLY
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
how to be use a stock maintain in a stores.......purchase & sale ,debit & credit pathi sollunga sir
Clear explanations
Bill podumbothey innoru sheet la date oda bill amt save aganum ..... panna mudiuma sir
I try it it throw error like #spill , what the problem sir.
Nice work...
Sir, if error la , 0 pathila empty a varanum ,athu epdinu sollunga
Thanks a lot sir..
Ithula sgst cgst and offers athula ebdi podrathu sir
For your referenceth-cam.com/video/HWoeyVGHWy8/w-d-xo.html
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
How to do date wise sales
Thank you sir...
Could you please also add a scenario where Approximate Match would be used
Nice one .
Thank You
VLOOKUP(look,table,2,0) here i couldn't understand how the 0 comes. Can u tell bro? Anyone else?.
Dropdown List Tamil font eappade use pandrathu sir
Circular reference error varuthu bro enna pandrathu
how to add new itam
Thanks
Sooper sir
Thanks Sir
Bro (e-library) PHP project madiri ennoru project podunga waiting bro...
Sure
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
According to vlookup day 9 video
Thank you
You are Welcome
Thanks jee
You are Welcome
Weekly course bootstrap latest version tutorial upload pannuga sir plz...
Sure We will Upload it Soon
In 2m 34 sec Alt + Down Arrow List out Drop Down
Thanz sir
You are Welcome
Explain Hlookup
CELL
how to be use a stock maintain in a stores.......purchase & sale ,debit & credit pathi sollunga sir
Thanks 👍
Thank you