Find Last Match - Find Method | Excel VBA Tutorial in Hindi

Find Last Match - Find Method | Excel VBA Tutorial in Hindi
For online classes, please contact us at 93100 73387

Suppose you have an employee database in an excel sheet, In this sheet you might have multiple entries for the same employee, as when an employee got promoted you need to add a new row for the employee with the new designation and promotion date. Now if your boss ask you to fetch the the current designation for all the employees from the excel database. What will you do? Will you search manually? Or Will you use vlookup for the same? However there is a better solution. You need to first sort your data by DOJ/PromotionDate column in ascending order and the search your employee using Find method and pass xlPrevious value in SearchDirection paramenter of Find Method.

🎧In this video, you will learn
►How to use SearchDirection parameter of Find Method in VBA
►How to find last match of an employee in excel database using Find Method
►How to use offset Method in VBA

Hope you found this video useful. Please like, share and subscribe to our channel. This will motivate us to create more good contents. Thanks!

💜You Might be Interested in (Free Tutorials):

➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖
🎧Do watch our Other VBA Videos (Hindi) 👉
➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖〰➖

--------------------------------SOCIAL--------------------------------

#findvba #findprevious #vbafind #findinvba #excelvbafind #excel #vba #excelmacros #automationfever

[rewatiraman]

very very useful and clear details given

[aamir]

Dear sir it gives me the first entry but I want the last match please help me