I have a list that comes with data from other spreadsheets. Make a MAJOR to go back to the 1st major, then the 2nd, and so on. Then I make a PROCV to get the name for that value. Until then, OK.
The problem and the doubt: How to break because if because if for example they have 2 values 18 with different names, it only takes the name of the largest.
Is there any way to resolve this? Another thing: inside this file has several spreadsheets (year1, year2, year3) how can you put this name of the worksheet (below) in a cell, using some information about it?
I know there are two doubts, but the main one is the tiebreaker, if possible. I use Excel 2016. Thank you in advance for those who can help.