Please try at E4
=IF((C4="Urgent")*(D4>=H$2)*(D4<H$2+29),SUM(N(FREQUENCY(IF((C$4:C$23="Urgent")*(D$4:D$23>=$H$2)*(D$4:D$23<H$2+29)*(B$4:B$23>B4),B$4:B$23),B$4:B$23)>0))+1,"")
14 May is more than 15 Apr
I add D$4:D$23<H$2+29 to check date with in a month
Last edited by Bo_Ry; 10-02-2020 at 06:44 AM. Reason: Correction
Thanks Bo_Ry for your response.Originally Posted by Bo_Ry
I tried using your formula but i guess its taking account of the maximum function and thus ranking ranking price of approx same value i.e., 3.5-3.44-3.3 with the same rank.
The sheet is attached for your reference.
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks