Hi,
I’m looking for some expert advice on being able to solve a problem that I’ve been stuck on for quite some time now…
Here’s what I have…
•Book 1 has some data with “Time” field and I need to populate the time for the corresponding entry into Book 2. My required Output is in Column G of Book 2.
I’ve attempted by concatenating data and trying to use VLOOKUP but that doesn’t seem to be working in the desired way obviously as it only picks the first instance.
Then I tried to create unique IDs by assigning unique IDs by way of =COUNTIF($D$2:D2,D2) using multiple permutations and combinations, but to no avail… The biggest challenge is that the number of entries between the 2 aren’t the same. For example: Row 7 to 22 in book 1 isn’t the same in number. There are only 3 instances of it in Book 2 Row 4 to Row 6.
In the above case, there is only one similarity which is the status so I need to pick the maximum time for the status of each entry corresponding in Book 2. Therefore, to help understand I’ve manually picked the Max time of Status “DN” and ignored the rest of the rows for the Same entry (highlighted in black).
Could you please assist me in solving this “Monster”. Hope the above makes it a little clear now sir
Please advise.
Thanks a bunch!
Bookmarks