Hi all,
Have attached a sample sheet where rows A to L have a value. I want to be able to return the value in the row that has the most matched entries. In the sample it would be number 4 with 3 counts as shown in M and L.
In the (likely) event of 2 or more numbers returning the same count I want to return a NIL result for that row.
Hope that makes sense.
Cheers
Hammer
Bookmarks