I am using 2003. I can't find any reason for the problem to be related to the
version. Either. Sigh...

"Duke Carey" wrote:

Your formula works perfectly for me. I'm using Excel 2007, but can't see any
reason the version would cause a difference

"Outlook, eh?" wrote:

Yes. In my case your formula would look like this:
=IF(M2="","
","ImportId-"&TEXT(SUMPRODUCT(--ISNUMBER(SEARCH("Import",$K$1:K1)))+1,"00"))

BTW This is what the data file really looks like:

K L
M
Header Header
Blank
(Blank until function puts info in) Old Data
802-888-8777

"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