Find, match, alocate functions??

Hello there, i will be verry happy if someone could help me. At work i do every week a statistic in excel and i need to analise around 2000 number and i do that manualy, look at this video to understand the ideea and what i do :

https://www.youtube.com/watch?v=E0bQXtw44Kw

can i code all this work or at least half of it, hope there is an way with macros or excel functions, you will save one day of my work guys...(kind of noob in vba/macro function.....) loked around the net, this site others and is kinda hard to find a propertly function...

Please who have a little ideea please help me!!!!