fastballfreddy
Board Regular
- Joined
- Jan 13, 2015
- Messages
- 57
- Office Version
- 2016
- Platform
- Windows
I'm trying to match two columns of data while not matching the same value twice. the match formula just finds the first value. the below example when matching data 2 the 5 always matches the first 5 in Data 1. Is there a formula so once the first 5 is matched it will match it with the 2nd one and so on?
Data 1 | Data 2 | Match Formula |
5 | 20 | 3 |
25 | 5 | 1 |
20 | 5 | 1 |
5 | 45 | #N/A |
15 | 5 | 1 |
5 | 5 | 1 |
5 | 50 | #N/A |