|re: "I have huge excel file with around 7 lacs entries"|
What's a "lac"?
Without knowing the layout of your spreadsheet, we can not offer a macro solution.
Please click on the Blue Line at the bottom of this response and post a subset of your data so that we can get a better understanding of what you are working with. Make sure that you remove/modify anything that could be considered confidential.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.