Share via

Multi-conditional search returns non-duplicate values

BABY_JOJO 241 Reputation points
2023-01-31T13:30:49.5366667+00:00

Returns the non-repeating value of column A according to the date and name

User's image

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,950 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
0 comments
Accepted answer
  1. Emily Hua-MSFT 27,651 Reputation points
    2023-02-01T05:25:59.11+00:00

    Hi @BABY_JOJO

    According to your sample, please try following formula.

    =UNIQUE(FILTER(A$2:A$9,(B$2:B$9=$G$2)*(C$2:C$9=$F$2)))

    Capture59

    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.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.