excel scripting Q

• morphinelips

  I have a .csv file that I would like to import into a mySQL database, but I want to make a column in excel that serves as the key and increments from 1 to however many rows there are.

  1
  2
  .
  .
  .
  10000

  I know I have to use something like =COUNT(A1:THISROWNUM) but I don't know how to determine the current row.

  Thanks for any help...

  morphinelips

  Flag

• morphinelips0

  ooh, found it.

  =row()

  morphinelips 0Permalink

  UpvoteDownvote

  Dogear

  Flag

  Show [[ numHiddenNotes ]] more notesAdd Note

  SaveCancel