@snb, yes, I think that is similar to OP's original formula (MAX rather than LARGE), however, you need to adjust either your use of ROW or initial INDEX range - as is you are offsetting by 1 row.
@snb, yes, I think that is similar to OP's original formula (MAX rather than LARGE), however, you need to adjust either your use of ROW or initial INDEX range - as is you are offsetting by 1 row.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks