Question: Apologies for the confusing question title, I wasn't sure how to describe the problem.

Background and objectives:
I have a large dataset in Excel, near 1 Million rows.
I have a key field (not primary cause there's duplicates).
The key field will become the primary key field in a new table.
For every row with the same key field in the original dataset, I need to:
 Find the max of one of the columns
 See if a text string exists in one of the columns
Then I'd like to put the key field, the corresponding max, and the corresponding result of the text search into a new dataset in one row, 3 columns.

A VBA or PivotTable solution is acceptable. Given the size of the dataset, code efficiency/memory management is critical.

Thanks in advance, any kind of help would be appreciated!

Answer: 
i had the same issue, try this : 
open a new file and check the color mode at the beginning. then open up your file again!
When you save a file it gives you various colour management profiles depending on your set up (or needs). If you save without any colour management profile then the colours will be true