=IF(C1=""," ","ImportID-01")
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
|