How can you find multiple match in a cell and select the one with the latest date attribute to it

Jimmy509

New Member
Joined
Apr 18, 2019
Messages
29
Hello my fellow excel-ers,
I am trying to find search through a range of cells in column A from my excel spreadsheet. I know that I can use .Find to find the first match in that range or use .FindNext to find all of them. But my issue is I would like to find the match for my latest transaction. In Column B I have a range of dates for each transaction.
The transaction ID repeat multiple times for different date. I would to select the date that is the most recent.
I am new to excel VBA. Can anyone help me please.
 
Some adjustments:
Change the datatype of dtMax to Variant

Immediately after the For each rCell in Range("D2:D4") insert this line
dtMax = "Not Found"

In the first Find insert this parameter
LookAt:=xlWhole


M.

ThAnks a lot. I’m getting through it but I reach an error when I tried to set my last cell. Because I am not using a specific range. I am using
with sheet.cells
“ get last cell “
End with
 
Upvote 0

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top