Almost there Duke!

It is placing 0s in the field next to where the data is. So it is finding
the correct fields, but it isn't placing ImportID-01 and then increasing by
1. Thanks so far!

"Duke Carey" wrote:

This requires that row 1 be blank. Change the $A$1:A1 portion to reference
the column whre you place the formula

=IF(C2="","","ImportID-"&TEXT(SUMPRODUCT(--ISNUMBER(SEARCH("Import",$A$1:A1)))+1,"00"))

"Outlook, eh?" wrote:

Hey all,
As you can see the formula will fill a column next to any fields that are
not blank with ImportID-01. This works really swell, but I would like to also
increase the 01 by 1 so that it looks like this:

ImportID-01 Ringo

ImportID-02 Paul
ImportID-03 John


ImportID-04 George

Any ideas??

Thanks, you guys have never failed me! I appreciate it so much..
Bryce