Search results for query: *

The Match function has 2 problems why I'm not using it: * It returns only the first hit and I need to skip hits once it has been successfully matched * It only works for 1 on 1 matching, where as that only represents about 40% of the total matches. The others are 1:x matching where 1 value in...

They are not unique values, so from my understanding the match function will only pick up the first one and I need to skip the value once it has been matched. Plus I need to know the cell it references, because if I loop through everything I need to give it another color based on the fact that...

Yes, 1 value in column A matches a number of values in Column B. Just how many is not defined so in the easiest match it would simply match 1 value on Column B. In more difficult situations it would be that 2 values in column B would match 1 value in Column A. Basically Column A are settlements...

It is, just not on those columns. I could try and see if I can have it sorted as well on those columns, but what difference would that make? The columns do contain multiple similar values, so vlookups still wouldn't work as it would still pick up the first one. The main issue I'm having...

No, it's not always 4 values, it's a mixture of 1:1, 1:2, 1:3, 1:4 right up till 1:8 is the most I've seen. Around 80% is 1:1 matching and they should be identified and the color of the cell should change. All of that is no problem to program, but if I want to do 1:5 matching that basically...

Hello, the issue I'm having is that I have 2 columns on different worksheets that contain values that match to each other. The easy ones are the 1:1 matching, simply take the first value, compare that to the other one and if they match do whatever needs to be done. I loop through the X values...