Check values and Add Missing

**NBVC** · 05-13-2010, 01:14 PM

Probably better to add another column simultaneous to your column B..

=IF(AND(LEN(B3)=5,B3=LEFT(B4,5)),B4,B3) copied down.

**John Bates** · 05-13-2010, 01:27 PM

Hi NBVC,

Thanks so much for your help!!

What would i need to do in the case that the values were not sorted in order in column A. See the attachment (Random Order! worksheet).

Thanks!

PS - and wanted a dynamic formula that would take care of things for me without having to sort using the Sort&Filter editing option.