Compare and combine duplicates

In the example below, I am using the following code (generously provided on this forum) to combine duplicate cases (column A), by filling in the blanks of one duplicate with the value of the other.

However, some duplicate cases (such as cases 10 and 11 for attribute 2) have different values, but same case number. How can I amend this code to choose the higher one? (and still perform the combine function of the code)

What I have
Capture.JPG

What I'm trying to get
Capture2.JPG

Please Login or Register  to view this content.

Try such code:

Please Login or Register  to view this content.

Note that your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Kaper's solution is quite a bit more elegant than mine, but i wanted to play around with arrays anyway and came up with the following.

One note, I believe Kaper's (and the example you provided) only works if the duplicated values occur in subsequent rows. Mine will work even if the duplicated values are out of order. someone more talented than me can probably make this quite a bit cleaner.

Please Login or Register  to view this content.

hmm... i'm not seeing that issue. do you have all your headers in row 1?

Originally Posted by simarui

...I believe Kaper's (and the example you provided) only works if the duplicated values occur in subsequent rows. ...

As shown in original question on screenshot ( :-( ) attached.
PS. Code is not mine - it is original code with one minor modification to fulfill request. Personaly, I'd do this probably also with arrays (or may be other data structure) because deleting a lot of randomly positioned rows in the middle of long range is time consuming process.