This video demostrates how to FIND the "First & Last Occurence" or "Match" in a Column of Data. In this example we have a data set of client payment history that contains multiple payments made for the same client. The objective is to first sort this data set by Client Name and then find the First and Last Rows that one of those clients is located on. After that we want to copy those rows of data for that particular client into a new tab of our workbook.
Learn More about Excel VBA & Macros with this Book on Amazon:
amzn.to/3xnqT6R
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
To get a copy of the workbook used in this video click the link below:
theexcelcave.weebly.com/excel...
#ExcelVBAFind
#ExcelVBAFindFirstAndLastMatch
Негізгі бет Excel VBA Find First and Last Match in Column
Пікірлер