I was graciously helped previously to help find a value in the first row of
an array when changing the autofilter, but now how do I figure out the last
row?

Here's the formula to find the first row.

=INDEX(B15:B48479,MATCH(1,(SUBTOTAL(3,OFFSET(B15:B 48479,ROW(B15:B48479)-MIN(ROW(B15:B48479)),0,1))*(B15:B48479<"")),0))

I want to be able to compare the first and last row and see if they are the
same or not.

Thanks so much for looking at this!