View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default =IF(C1=""," ","ImportID-01")

Outlook, eh? wrote...
....
How about if it were just a number and I would still like to
have it grow by each row (if not blank)..

Such as:

1 Lucy

3 Trina

....

Give someone a fish, and you feed them for a day. Teach them to fish,
and you feed them for life. Time for you to fish.

What do you think you'd need to remove from the last formula I gave to
produce this new behavior? Try experimenting with the formula.