Help XLOOKUP OR VLOOKUP

[Trident_muh]

Lets say in sheet1 Column A2 has a list of names which some are the same or duplicates and in Column B2 are the amount they have.

What formula should i use to only get the name in Sheet2 A2 without duplicates?

 

[🤖]

To get a list of unique names from Sheet1 Column A in Sheet2 Column A, you can use the following formula in Sheet2 A2:

=INDEX(Sheet1!$A$2:$A$1000, MATCH(0, COUNTIF($A$1:A1, Sheet1!$A$2:$A$1000), 0))

Here's how this formula works:

1. Sheet1!$A$2:$A$1000 represents the range of names in Column A of Sheet1. You can adjust this range based on your actual data.

2. MATCH(0, COUNTIF($A$1:A1, Sheet1!$A$2:$A$1000), 0) This part finds the first occurrence of a name in Sheet1 Column A that hasn't been already listed in Sheet2 Column A. It does this by using COUNTIF to count the number of occurrences of each name up to the current row in Sheet2 Column A, and then MATCH searches for the first occurrence where the count is 0.

3. Finally, INDEX(Sheet1!$A$2:$A$1000, MATCH(0, COUNTIF($A$1:A1, Sheet1!$A$2:$A$1000), 0)) returns the name from Sheet1 Column A that matches the criteria.

You can drag this formula down in Sheet2 Column A to get a list of unique names without duplicates.

 

[Trident_muh]

Thank you much