Comparing the multiple values returned against index/match

Hi there,

I have an index/match formula for which there are multiple values returned. I don't need to list out the multiple "hits" so-to-speak, but I want to be able to compare all the values that would be returned against my index/match and see if any are equal to each other. For example, if the index/match function could hold true/return 5 values, are those values equal to one another? If yes, return "TRUE" if no, return "FALSE".

Thanks!

Can you please post a small file with sample results.

Book3.xlsx

Try this, please.

Perhaps I don't understand your requirement ... a simply COUNTIFS of Customer No and Item No. found no duplicates.

And as you have not included your INDEX/MATCH I was unable to verify my assumption above. And what does equal mean - how many fields?

Book3.xlsx

SOrry, in my attempt to scrub my spreadsheet to remove identifying info I oversimplified it. In the attached example I have 1 customer w/ many ship-to locations. The same items get shipped to more than one location, which is where the index match comes in. I have included the index/match formula now. Thanks for your help!

I have established there are 5, 14 and 6 matches on the sample you gave.

Which values have to the checked to see if they are the same: in the first set of 5 there are two shipments to Location Code WH008, 2 to WH012 and 1 to WH017.

Is it the WH008/WH012 pairs that need identified? and how do want the data presented?

I'll be signing of shortly but will look out for your reply.

It's the "whse allocation" value that I need identified. Then I need to see whether the values are the same or not. We are trying to identify item/customer combos where the "whse allocation" is evenly distributed (so this value is equal for each Location Code).

I would imagine you are signing off for the day--it's late in England! Tomorrow will be just fine as well, thanks!

Not sure where to go from here (see attached).

I am unable to construct a formula which will extract the required combinations and then compare the "whse allocation".

You might require VBA to do this,