Find Missing Data using Vlookup and Conditional Formatting - Tamil | Prabas MS Office

[@elaikamal9579]

ரொம்ப ரொம்ப நன்றி சார்... இதை நான் பலநாள் தேடிப் பார்த்தேன் இப்போதுதான் கிடைத்தது

[@Prabasmsoffice]

இந்த காணொளியை பார்த்தமைக்கு நன்றி. இன்னும் பல பயனுள்ள காணொளிகள் நமது CHANEL இல் இருக்கின்றன, அவைகளை கண்டு பயனடையுமாறு கேட்டுகொள்கிறேன்.

[@vetrivelp8774]

எனக்காக இந்த காணொளியை தந்தமைக்கு மிக்க நன்றி. எளிமையாவே இருந்தது. இரண்டு விதமான முறைகளும் பயனுள்ளதாகவே இருக்கிறது. நன்றி.

[@str2290]

ரொம்ப அழகா, தெளிவான விளக்கம் அண்ணா . ரொம்ப நன்றி. உங்க வீடியோ தொடர்ந்து பார்த்து வருகிறேன்.

[@Prabasmsoffice]

+kuttimma sankar நன்றி தம்பி

[@ArunKumar-ux3wt]

Sir your voice is very nice and clear explanation and expecting more videos

[@Javidh747]

வாழ்க வளமுடன் @Prabas Sir

[@sredharbalaraman1387]

Explained nicely. Interesting.

[@tharunkumar1958]

Useful for me to compare Annual expenses of current year and Previous Year Thank you so much for the video sir.

[@1gopalakrishnarao]

Excellent. Well explained. Very easy to understand. Very Useful to the Excel users.Thanks, expecting some more tricks/tips.

[@Prabasmsoffice]

+Gopala Krishna Sure, thank you sir.

[@muralimv5588]

Very nyxest voice and good explained sir most of the time I searched itt thank u much love...!!!

[@Prabasmsoffice]

Thanks for your positive comment. Keep watching and learning. kzbin.info/aero/PLXqX9fbIzJMabaqSMTD-CLMwfYdoVR7AS

[@kodairoadkannan]

super great

[@Janushika2021]

Nice sir..

[@selvakumar-px9dl]

Thanks ji

[@Prabasmsoffice]

Hope, you have subscribed to our KZbin channel. PrabasMsoffice.

[@nazarkamal8831]

Nice video sir

[@manickamnavaneshwaran4497]

Super

[@kvvkannan293]

Thank you so much for your information sir

[@Prabasmsoffice]

Keep exploring our other videos too. 👍

[@MohanKumar-in5bi]

Thank you sir

[@selvanprem8040]

Foxpro file ஐ XLல் 0pen செய்யும் பொழது date மட்டும் formateல் வறுவதில்லை நம்பர்போல் வறுகிறது foxproல் உள்ளது போலவே வரவழைப்பது எப்படி? pl.Sir. Thanks

[@arnocopyrightvideosmusic8112]

Hello Anna good evening... Please anaku sollunga ...Na excella logs & incidents type pandran illaya, appa na daily annudaiya Management ku Ada sent pandradu walakam, ippa annudaiya kelvi annanna! Normally last week la ulla oru log udaiya oru pege ga appadi click and open na katradhu? I hope you understand my question......Na konjam unique ka management ku kanbikka pakkuran ....so Anna your solution highly appreciated if you can help me.... advance thanks....

[@aramuramu8834]

Sir ms excel use pannunean andha folder il Ulla edhuvum kanala delate pannama file kanama pochu adha eppudi thirumba edukkalam recycle layman illa

[@saravananmuralidharan498]

Sir enaku mis executive jobuku enna enna formulas therinjakanum konjam skllunga sir

[@Prabasmsoffice]

Have a look into our KZbin community. You will get answer for your question.

[@sureshrajan3152]

Please Upload Excel Automation Video

[@Prabasmsoffice]

Sure

[@sureshrajan3152]

Thanks

[@karims9355]

Dear brother your way of explanation is too good... as I am excel 2010 I want extract only missing values from 2 columns without empty cells through formula... can you please help...

[@Prabasmsoffice]

Share the Excel to [e-mail]

[@rajasanthosh9617]

Sir, One doubt, how to find missing serail number in rows eppadi sir solve pandrathu

[@Prabasmsoffice]

Send your data structure to understand your question better....

[@gurub5773]

Praba hope we use that duplicate count if with data validation for this same occurrence. Advice me if it's worng

[@Prabasmsoffice]

+guru sundaram Yes we can, but how will you filter them if you have huge data set.

[@Prabasmsoffice]

+guru sundaram Have you tried, guru?

[@gurub5773]

With in 2 or 3 we can but more column doubt

[@Ridetoright111]

Good ... Praba எனக்கு ஒரு சந்தேகம்...(F4)...Formula lock பண்ற concept யார் சொல்லி கொடுத்தாலும் புரிய மாட்டேங்குது.. lock pandra logic ஏன்? என்ன காரணத்திற்காக lock pandrom ..கொஞ்சம் சொல்லுங்க.. நான் நிறைய data'la vlookup use pandren but இந்த formula lock scenario மட்டும் எட்டா கனியா இருக்கு..😀😀

[@Prabasmsoffice]

Sure, I will try to post a detailed video for this.

[@Ridetoright111]

@@Prabasmsoffice thank you...

[@malaravanmm6727]

Bro How to download Google map? Please Help me

[@Prabasmsoffice]

This link will take you to the steps to download / save google map for offline access.erinlyyc.com/2017/05/17/how-to-save-google-maps-directions-for-offline-use-when-travelling/

[@malaravanmm6727]

Thank you Bro....

[@packiasekar9767]

sir i have 1000s entries i want 0 instead of n/a, what is program, ie isna or if etc please

[@Prabasmsoffice]

+Mukul sekar.p You can control this using number format. Watch the below linked formula to get some idea. kzbin.info/www/bejne/nYbCqJeubMx-nrs

[@sharveshwariswaminathan6208]

If error formula use pannunga

[@Prabasmsoffice]

+Sharveshwari Swaminathan Good contribution Shaveshwari.

[@Prabasmsoffice]

example is given below. =Iferror ( vlookup ( lookupvalue, array, column index nunber, 0),"0")

[@thenmozhi3095]

Sir easy ya irukku but naan try panna varala

[@Mrs.Anitha.p]

Hi , how to find vlookup left to right

[@Prabasmsoffice]

+ramesh vetri Use index Match. kzbin.info/www/bejne/nWTciqGZbN6DrJo

[@gurub5773]

Vlookup with choose function

[@packiasekar9767]

iwant value 0 instead of NA COLUMS, WHAT IS FORMULAE

[@Prabasmsoffice]

Then IFERROR formula will be helpful. =Iferror ( vlookup ( lookupvalue, array, column index munber, 0),"0") Embed you vlookup formula into iferror formula. Your problem will be solved.

[@dm-zd5nu]

sir ur practice files some times does not match to ur content(video).kindly here after bit take care upload practice files which related to content...thank u

[@Prabasmsoffice]

Thanks for your suggestion Dinesh, I check them in the future updates.

[@aramuramu8834]

Sir number pls

[@Prabasmsoffice]

[e-mail]