Question:
I have a dataset in Excel that contains information about PIDs, Customer_numbers, AccountSeqNums, and Transaction Dates. I am trying to find the missing PIDs based on specific matching criteria, but the formulas I have tried so far have not produced the desired results.
Here is an example of the dataset:
I want to find the missing PIDs where the Customer_number matches a specific value and the AccountSeqNum matches another specific value. Additionally, I need to exclude any rows where the PID is already filled.
I have tried using formulas like INDEX, MATCH, and COUNTIFS, but I haven’t been able to achieve the desired results.
Could someone please help me with the correct Excel formula or approach to find the missing PIDs based on these criteria? Any assistance would be greatly appreciated. Also, Columns D, Transaction Date will have several missing dates.