LinkBack URL
About LinkBacks
Array entered
=SMALL(IF((C5:C156=I1)*(D5:D156=J1)*(G5:G156<>""),G5:G156),1)
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
Array entered
=SMALL(IF((C5:C156=I1)*(D5:D156=J1)*(G5:G156<>""),G5:G156),1)
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks