Hi together,
I hope you can see this picture and my excel file. It's an example for my problem.
In reality i got a lot of more data so i cant handle this manually.
The most important thing ist to look for the same MP NR. In this example there are just two possibilities, 1 and 2. For all rows with the same MP I need to calculate the same calculation to get an weighted rating. You can see the needed calculation in the picture.
I spend a lot tiime with solving this problem and also spoke to my collagues but all of them didnt know how to manage it.
Im really unsure if its possible at all.
It would be great if you can help me. Even if you say its not possible you could help me.
Thank you!
Bookmarks