hai, can everyone help me to change this formula to vba code :
Excel Formula:
=SUMPRODUCT(($E$2:$E$63184=E2)*(U2>$U$2:$U$63184); ($F$2:$F$63184=F2)*([U2>$U$2:$U$63184))+1
it's been a week since I tried to find the right code for this formula in vba, but still the result is always error
Crossposted here: https://www.mrexcel.com/board/thread...oduct.1233849/
Bookmarks