Dear Members,
Refer the attached sheet.
I want to Rank ITEM in col. A. Rank 1 is to be given to any Item marked with "XXX" or "YYY" in col. E. The rest of ranking is to be given to only Urgent items (Col. C) with their date (Col. D) is greater than or equal to I2 cell.
with the help of the excel forum i have derived an formula (Col. F) however i am not able to include a condition so that Col. E marked item should be ranked 1 then the rest.
Kindly help me to create a formula so that i could get my ranking as desired.(Col. G)
Thanks in advance
Bookmarks