the question is how do i populate colC 3 with '20125269' as in the should be. the first 3 rows represent the sheet as i have inherited. i could not come up with or think of a formula that would do this, since the rows are not consecutive, i have put them like this as illustration only. hope this makes it clearer