Re: auto number with duplicate -first-last bench
SECOND REQUEST column: You want to copy over the number from "First Request" (you'll want to check your spelling on "first", by the way).
The way I would do this with a formula is put your cursor in cell G3 and use:
What this says is, if there's no number to the left of this cell, simply copy the cell above this one, but if there is data to the left, copy that. In this case it would copy the "1" over. If you fill this formula down the column it should work for you.