I'm aware that excel has some list functionality, though unsure if they can function in my example. I have my Magic: The Gathering card inventory stored in a spreadsheet.
Column A represents the name of the card. The same value can appear in this column multiple times as cards have been reprinted over the years. Column B is the name of the set in which the card was printed in. So for example, a value in Column A could appear four different times, always having a different value in Column B. A different value in column A may have only been printed one time, thus having only one value in Column B.
I have broken the values of Column B into three lists, for now we'll call them 1, 2 and 3. Using the example of the column A entry appearing four times and having four different values in column B, let's say the list the Column B entries are on are, respectively, List 1, List 2, List 1, List 3. What I would like excel to do rather than spit out the return for the four rows like this is give me the highest list any of the four appear in, so I'd like it to return List 3 for all four rows with the same value in Column A.
Bookmarks