Thread
: [Solved]
Looking for the correct formula
View Single Post
09-09-2019, 04:24 PM
jeffreybrown
Windows 10
Office 2016
Expert
Join Date: Apr 2016
Posts: 673
Give this a try...
=IF(SUMPRODUCT(($A$2:$A$30=A2)*(B2<$B$2:$B$30))+1> 1,"Y","")
or
=IF(COUNTIFS($A$2:$A$30,A2, $B$2:$B$30,">="&B2)>1,"Y","")
jeffreybrown
View Public Profile
Find all posts by jeffreybrown