It worked! Thank you so much Nirmal!!!!

Thank you but it is only giving me the max date based for each historical status name. Thank you for the suggestion!!!

I tried using "Is Most Recent" but it doesn't work as it is the same offer that has been accepted then declined - both records show "Yes". Thanks for the suggestion though.