Create Sequence Number Countdown Rows in Table

[JarekM]

Hi, I tried to create a sequence list that would go from highest to lowest. I have found a video that does it but it only works for Excel 365 and I don't have that version. Also, the formula he used is static, but I need to be done dynamically, to the base of the rows in the data table. I need a formula or VBA code.

Here is the link:

He shows how to do it at 6:50.

Here is a picture from the video:

 

[JamesCanale]

It doesn't have to stop at R15 in my example. You can make it R9999 if you please. Or just use "R:R" and subtract one for whatever header rows you might have text in.