I have to do an index function where I know the column number I want, but the row number has to be the minimum of a list of dates. How do I do this?
I have to do an index function where I know the column number I want, but the row number has to be the minimum of a list of dates. How do I do this?
Hi
Without knowing your exact structure something like:
rylo![]()
=INDEX(B:B,MATCH(MIN(A:A),A:A,0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks