=MIN(MMULT(--(ROW(D4:D20)>=TRANSPOSE(ROW(D4:D20))),D4:D20))
This is an array formula, confirmed with Ctrl+Shift+Enter.
Also, this was fun to research.
=MIN(MMULT(--(ROW(D4:D20)>=TRANSPOSE(ROW(D4:D20))),D4:D20))
This is an array formula, confirmed with Ctrl+Shift+Enter.
Also, this was fun to research.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks