I NEED TO GENERATE A RANDOM NUMBER BETWEEN 1-9 BUT NEED TO EXCLUDE
WHATEVER IS IN THE CELL ABOVE IT. IF THE CELL ABOVE IT SAYS 8. I NEED
TO GENERATE 1,2,3,4,5,6,7,OR 9. IM STUMPED?

On way:

In A2:A100, put
=RANDBETWEEN(1,8)

In B1, put
=RANDBETWEEN(1,9)

In B2, put
=A2+(A2=B1)
and copy down to B100

Use the values in column B.