If anyone is able to help me with the following problem would be amazing. I have a set of values in a list, and would like to check those values against a column of data, count and list them in descending order. If an item from the list is not found in the column of data, I would still like the value to be listed with a count of 0.
I am attaching an example spreadsheet. The column on the left is a small part of the actual data, and on the right a small example. Preferably, a UDF would be ideal as I have tens of sets of data that keep changing and many different values to be checked spanning across multiple columns. The actual data is around 5000 rows with approx. 100 values to be checked against the data.
I would prefer to get the results as in the attachment but if thats out of reach and is more convenient to put the results in a different manner, please do.
Thank you for looking,