Excel formula returning multiple values according to two criterias

0 votes
I'm seeking for a formula (without VBA) that can, for example, show the places in Column F where there are persons with the same names in Column G and the same birthdays in Column H.

I tried combining INDEX + Fit with COUNTIF or VLOOKUP, but either I only had the first Location match the list's requirements or I got an error.
Jan 26, 2023 in Others by Kithuzzz
• 38,010 points
236 views

1 answer to this question.

0 votes

Unique Column Cells With Two-Column Duplicates

enter image description here

=LET(rCol,F2:F16,uCol1,G2:G16,uCol2,H2:H16,
    uAll,uCol1&","&uCol2,uOnce,UNIQUE(uAll,,1),rBol,ISERROR(XMATCH(uAll,uOnce)),
UNIQUE(FILTER(rCol,rBol)))

I hope this helps you.

answered Jan 26, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
0 answers

What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,010 points
207 views
0 votes
1 answer
0 votes
1 answer

Pass multiple Excel cell values to Power Automate

If you have certain data that you ...READ MORE

answered Nov 20, 2022 in Others by narikkadan
• 63,420 points
786 views
0 votes
1 answer

How to simplify adding multiple countifs formula in excel

If the Excel version you are using ...READ MORE

answered Nov 26, 2022 in Others by narikkadan
• 63,420 points
391 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,238 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,425 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,670 points
699 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
2,332 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,420 points
955 views
0 votes
1 answer

Excel Formula to convert from cm to inches and feet & round off to two digits

Use the TEXT function to format, and ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
• 63,420 points
595 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP