Is there a way to use the match function but for it to skip the first match found and look for the second or third match?
What I've got so far is a formula that first uses the large function to find the first, second, third, etc... highest number in a column. I then use the match function to locate how many rows down it is at. The problem I've got is that sometimes there's an identical number in the data list. The large function will say the same number is the third and fourth highest number in the data list but the match function will only find the first value listed so it finds the same row value for the third and fourth highest number. Thanks in advance for any help
Bookmarks