August 25, 2017
July 16, 2010
Thanks for sharing your file. You can generate the values in column X with this formula in cell X18, then copy down:
Enter with CTRL+SHIFT+ENTER
As for your next comparison, it's not clear how the values in column U were generated or the criteria for column Y's results. e.g. cell Y20 contains 9,7, but I only count 2 x 9s in cells U18:U20.
This second example needs the criteria explained for both the values in column U and column Y. That said, perhaps you can modify the formula above to achieve what you want. I recommend you have a go yourself first.