bearcub
Well-known Member
- Joined
- May 18, 2005
- Messages
- 757
- Office Version
- 365
- 2013
- 2010
- 2007
- Platform
- Windows
I am creating a report where I am using the filter function to list the monthly deals that our reps close. I am using the XLookup function in another column to extract the customer name associated with the dollar amount.
Two customers, in 2 different months, closed business with us that have the same dollar amount. Since Xlookup & Vlookup only return the 1st match.
I am trying to find a formula which will extract 2 customers with the same dollar amount.
![Duplicate Amount - different Customer.png Duplicate Amount - different Customer.png](https://www.mrexcel.com/board/data/attachments/110/110512-53af9c5a808e04718af17b4d3aa67357.jpg?hash=U6-cWoCOBH)
I have tried using the filter function but after I enter the formula it doesn't spill it just shows the formula (like it would appear without entering the "="sign).
Is there way to prevent the duplicate customer name from showing and showing the other customer with the same dollar amount?
Two customers, in 2 different months, closed business with us that have the same dollar amount. Since Xlookup & Vlookup only return the 1st match.
I am trying to find a formula which will extract 2 customers with the same dollar amount.
![Duplicate Amount - different Customer.png Duplicate Amount - different Customer.png](https://www.mrexcel.com/board/data/attachments/110/110512-53af9c5a808e04718af17b4d3aa67357.jpg?hash=U6-cWoCOBH)
I have tried using the filter function but after I enter the formula it doesn't spill it just shows the formula (like it would appear without entering the "="sign).
Is there way to prevent the duplicate customer name from showing and showing the other customer with the same dollar amount?