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!
The export for web uses sRGB. You use US Web Coated. Change your document to RGB mode and sRGB profile.

The sRGB color is the smallest RGB color space. 
You typically always work in the smallest space, even if your screen allows a wider RGB.