Very easy trick.. Ennakum intha problem face pannireken sir. My step is very lengthy. First convert the data into classic pivot table. Then sort by alphabetical. Then apply find duplicate value / unique value to cross check data. But your method is very quick to do findings. Thank you so much sir. Every time I learnt new tips from your videos..
Really very well explained sir, also I have one doubt oru attance format la particular ah 2nd Saturday & 4th saturday conditional formatting use panrathu epoadi
Good explanation sir, I have alternate formula for this. Without using helper column. We can use COUNTIFS formula.. Example: =COUNTIFS($B$3:$B$28,G3,$C$3:$C$28,H3,$D$3:$D$28,I3,$E$3:$E$28,J3) 1 means correct , 0 means incorrect
Sir good morning,,, online form for example student name, date of birth,male or female, phone no, email id.....intha details ellam Excel iruku itha epadi Nan ore time la online form la entry panradu. Sir please help me sir
I am using macro developed in ms office 2016 but know I changed to 2019 but macro didn't working it's password protected I missed the password kindly give some solution. 20cr we are paying per month using this macro. Kindly give solution to solve this problem.
Super sir
Super Learning JI
Super excited for this tips
Thanks you so much.
Super method
Excellent sir
Nice 👌 thanks sir
Sir super sir
Great job Sir 👍
easy to under stand brother
Super sir.
Nice it's very useful sir thanku
Really useful video sir, i share this with my friends too
Thanks Ebin, please refer our videos with your Friends.
Very easy trick.. Ennakum intha problem face pannireken sir. My step is very lengthy.
First convert the data into classic pivot table.
Then sort by alphabetical.
Then apply find duplicate value / unique value to cross check data.
But your method is very quick to do findings.
Thank you so much sir. Every time I learnt new tips from your videos..
Thanks for sharing your experience.
Incentive calculation video pannunga
Sure will do it.
Really very well explained sir, also I have one doubt oru attance format la particular ah 2nd Saturday & 4th saturday conditional formatting use panrathu epoadi
Pannalame.
Pls explain video sir
Sure, will explain in the future videos.
இப்படி ஒரு method இருக்க என்று இப்போது தான் நான்
பார்க்கிறேன். Thanks Sir வாழ்த்துக்கள்.
மகிழ்ச்சி.
மற்றவர்கள் கேட்க்கும் கேள்வியில் சிலவற்றிற்கு எனக்கு பதில் கிடைக்குது, ஆனால் மேலும் இருக்கும் சில கேள்விக்கும் பதில் கிடைத்தால் நன்றாக இருக்கும்
முயற்சி செய்கிறேன்.
Very useful problem solving bro.. I too faced such type of error in my real time workings....
Thanks Ranjith for sharing your experience.
Good explanation sir, I have alternate formula for this. Without using helper column. We can use COUNTIFS formula..
Example: =COUNTIFS($B$3:$B$28,G3,$C$3:$C$28,H3,$D$3:$D$28,I3,$E$3:$E$28,J3)
1 means correct , 0 means incorrect
Waiting for power bi
Sure, Will post Power BI videos soon. 🙏
Sir, Useful topic 👍
Sir xl caps, small, eppadi sir change pannurathu. Word la shift f3 mathiri xl any shortkey iruntha sollunga sir pls.
Sir good morning,,, online form for example student name, date of birth,male or female, phone no, email id.....intha details ellam Excel iruku itha epadi Nan ore time la online form la entry panradu. Sir please help me sir
Which form?
Microsoft Form (or) Google Form..
1st view sir
Need one help bro ...excell problem
Share your Excel problem to prabas@prabastech.com
I will try to support in my free time
2 data vaiyum sort Pana orey order la varum then easy ah compare panidalame bro? Just asking
What happen if you have uneven rows of data in both Excel?
Ok what about cell base calculation by using= it may work?
As discussed, please use the = operator accordingly.
Sir account number different irundha idhu work aagum ma
Give some examples
I am using macro developed in ms office 2016 but know I changed to 2019 but macro didn't working it's password protected I missed the password kindly give some solution.
20cr we are paying per month using this macro.
Kindly give solution to solve this problem.
We are using for tax purpose.
Will meet in prabas@prabastech.com
i think these one excel practice file was missing. kindly rechecked it
docs.google.com/spreadsheets/d/1TXOoUvF8son9gidYT0NV2V5yd4dVq3Ea/edit?usp=drivesdk&ouid=111627210847530176674&rtpof=true&sd=true
Sort
Can't find the file to download
Checking
@@Prabasmsoffice me also facing the same difficulties to find it please fix it.
Updated on our website, please check it out.
while I'm tired to download it's taken me into this home page. Anyways appreciate your efforts
Super sir
Super sir