LinkBack URL
About LinkBacks
I am using this formula in E4
=SUMPRODUCT(--(C4=$C$4:$C$23),--(B4<$B$4:$B$23))+1
However this takes the account of both "Urgent" & "Non Urgent" and also i am not able to think how bring the date criteria in it.
I am using this formula in E4
=SUMPRODUCT(--(C4=$C$4:$C$23),--(B4<$B$4:$B$23))+1
However this takes the account of both "Urgent" & "Non Urgent" and also i am not able to think how bring the date criteria in it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks