I have a large amount of data. I have a scenario where, in column BP (starting at row 6), I need to populate a formula that will look at the claim number in column AS. There will be multiple lines with the same claim number in AS. I need it to compare all the claim numbers that are the same, and check in the respective range in BO, and see if there is more than one discharge date (which is the information in BO), per unique claim number.
So, to better explain, I have 5 rows that have the claim number 12345, let's say. They may or may not be sorted so they are all together. I need the formula, if possible, to check for claim number 12345 in every instance, and tell me how many different discharge dates there are in BO for those rows. We're hoping they'll all be the same, but we are error checking.
Can you help?
So, to better explain, I have 5 rows that have the claim number 12345, let's say. They may or may not be sorted so they are all together. I need the formula, if possible, to check for claim number 12345 in every instance, and tell me how many different discharge dates there are in BO for those rows. We're hoping they'll all be the same, but we are error checking.
Can you help?
