How to create a cycle between two list's in Excel ?
I need help, please. I will try to explain the problem.
I have a list of parameters, which I will call k, to better understand the problem. I need to put each element individually from list k in a system that will generate another list x and I need to get the maximum value of list x for each individual element in list k.
Is there any method that I can use from Excel or a VBA tutorial that can help me?
EDIT_1:
Sorry for not being able to express myself properly.
-Both lists are numbers;
- I intend the biggest number in list X that is assigned to each number in list K.
I'm trying to automate this process, i took a print os me sheet in order to give a better understanding of the problem.
Image: https://ibb.co/yXhcXXW
Posted Dec 5, 2020, 11:02 PM UTC · edited
Your explanation isn't clear enough for me.