Excel is probably the wrong tool for that job. At the scale of a million rows or more, this is probably better done by a real database and programming language.