Excel Formula -- 2

Job ID: 35821755

Budget: $10 – $30 USD

Need a formula that can reproduce D how column D works is by

If there is Duplicate Value in Column A and in Column B and they all have matching names the formula then keep the highest in Column C.

Please sheet and example.
Related categories: Visual Basic Data Processing Excel SQL Data Analytics