Home » Questions » Computers [ Ask a new question ]

How do I get a reference to the last occurrence of a value in an array in Excel?

How do I get a reference to the last occurrence of a value in an array in Excel?

So if

Asked by: Guest | Views: 78
Total answers/comments: 1
Guest [Entry]

assuming your array is running off of a match of column values, I would suggest you just reverse the column values so values in column 5 of the array would now be in column 1, and then use min() instead. Getting the first occurrence is always easier than the last.