View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Outlook, eh? Outlook, eh? is offline
external usenet poster
 
Posts: 35
Default =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