Hello!
I am at wits end with this one having spent an entire day on it
My desired results are in Col D in blue.
I have unique Case ID's but duplicate codes. I want the Approved codes to show the approved Case ID by skipping blanks & picking the first match it gets.