Hello! I'm new here and could use some assistance. I have an excel sheet where I'm trying to write a function to see if a claim is valid or not. Column A is a name, Column B is a date, and Column C is my Formula. A claim is valid if the name is new or if the last 'approved' claim was more than 365 days ago.
My current formula now if: =IF(A3=A2,IF(B3>B2+365,"Approved","Denied"),"Approved")
This issue I'm running into is 'Mary' could submit 4 different claims where the 4th claim is more then 365 days past the 1st claim but less than 365 days past the 3rd claim. Because the formula is just looking at the row before it's wrongly denying the claim. How can I get excel to compare multiple lines together.
Thanks!
Bookmarks