Excel formula help

Question

Hi! Hoping to get some help creating a formula.

My data set includes an insurance company, CPT code, and a certain date. Anytime the insurance company and CPT in a given row match the same insurance company and CPT in any other row within the spreadsheet, I need to calculate 90 business days from the most recent date listed in all combinations.

For example:

Row 2 lists ABC Insurance and CPT code 12345 with a date of 1/1/2025.

Row 50 lists ABC Insurance and CPT code 12345 with a date of 2/1/2025

Row 128 lists ABC Insurance and CPT code 12345 (a match with rows 2 and 50). I need the formula to identify 2/1/2025 as the most recent date associated with that insurance and CPT combo and add 90 days to it and display it in a new column on row 128.

Answer 1

You are welcome. Check your image very carefully. You have only shown one date int he result column. Show the expected result very clearly. Also, share data in a format that can be pasted in an MS Excel file.

Answer 2

@Ashish - thank you so much for your suggestion. I did try this but only one date is appearing in column D. Column D should have a values for all though....I messaged you through your website.