multiple match

Hi, I am fairly new to Excel VBA. I have a set of matching values as shown in the picture attached. I would like to extract all the matching dates from the 7th column and extract all the 'unique dates' and list it in the columns against each matching values. I use excel 2016 . The Inputs are...

Hi, I have this data: UserID Date 1 03.22.2019 1 03.22.2018 2 03.22.2019 3 05.22.2018 3 05.22.2019 I would like to go through it using and select the user with the most recent...

Good day. What solution can you suggest to have “match” return value at column D if the code in column C matches with one of the codes in column G. The current job title code is referenced with the table of possible jobs for completers of certain skills training. In short, this is a problem...

Hi everyone, I am trying to do a reverse lookup to return column headers by matching the data items within a grid list. Currently, I am facing a difficulty in returning multiple column headers (Sheet 1) and they should be returned to a single cell in the "Interface Sheet". Interface Sheet...

I have a project where 60K records from the original worksheet have duplicate client # numbers. As in, the client placed multiple orders using the same client project key but we supplied different transaction ID's. The client has asked for report showing the difference in MARKET price...

Hi guys, I am hoping someone can help me get past this issue that i am stuck on. Going by the 2nd table below, i need to verify if the product# in the 2nd table matches the product# in the 1st table. If yes, then check if the "Sale Date" in table 2 falls within the range of Start & End date in...