I attached an example of the data I am looking at. I see it works perfectly on yours, so I'm not sure why it's not working when I put the code in.

tiger example.xlsm