HOW TO VALIDATE IF ATTENDEES IN A MEETING ARE ALL FROM THE SAME STATE

Hi @TERI RICE,

Thank you for posting your question in the Microsoft Q&A.

According to your concern, you can try using this formula in cell E2 and then copy paste it into the other cells:

=IF(COUNTIF($A$2:$A$9,A2)=COUNTIFS($A$2:$A$9,A2,$D$2:$D$9,D2),TRUE,FALSE)

In case you have a long data range, you can use this formula which will help you calculate the results in the whole data array all at once:

=MAP(A2:A9, D2:D9, LAMBDA(mtg,st, COUNTIFS(A2:A9, mtg, D2:D9, "<>"&st)=0))

Note: these formulas are using the data range in my testing worksheet. Therefore, you will need to change the data range with your current worksheet to ensure the formulas work properly.

I hope the information provided proves useful. Please proceed with the outlined steps and let me know whether they resolve the issue. If not, I’ll be glad to continue working with you to find a solution.    

Thank you for your patience and understanding throughout this process. Should you have any questions or need further assistance, feel free to reach out in the comments of this post. I'd be happy to assist you.    

Looking forward to your response.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".          

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread

Hi,

In cell E2, enter this formula

=BYROW(A2:A9,LAMBDA(r,COUNTA(UNIQUE(FILTER($D$2:$D$9,$A$2:$A$9=r)))))=1

Hope this helps.

< deleted > I would do a summary output instead of True/False down 1000's of rows.