Hi,
required a formula help which is calculate based on data/values contains in Col A & B in cell F3 Weeks to be taken for achieving a target, the target value is showing in Cell D4.
As well as in cell no F5& G5 required a formula which returns based on col A&B Over all best performed weeks (Top3)and sum the values incurred to same.
Based on col A&B calculate the Overall worst negative performed weeks return the same in Cell F7 and in G7 return the sum of incurred negative values where are values goes into minus.
In cell F9 return the weeks wherein no works are performed (Blank cells of Col B)
sample enclosed.
Thanks for the help.
Bookmarks