Thanks daffodil11, but I am a novice. Please let me know the exact formula. I have A1 To A15000 in sheet1 but A1 to A90000 in sheet2 and sheet 2 total filled up columns are up to column G.