Array
=MAX(IF(MOD(A1:A5,2)=0,A1:A5))
non array
=AGGREGATE(14,6,A1:A5/(MOD(A1:A5,2)=0),1)
Array
=MAX(IF(MOD(A1:A5,2)=0,A1:A5))
non array
=AGGREGATE(14,6,A1:A5/(MOD(A1:A5,2)=0),1)
Thank you. I wanted to have corresponding value so I used VLOOKUP along with MAX IF MOD.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks