All,
Very much need help on this one!!
I have attached the example so please ping if its not clear,
1. I need to be able to rank the planning and policy cost for each code (multi criteria)
2. I need to be able to calculate the median for each planning and policy division
Any and all help would be truly appreciated (and If I'm honest fundamental to me getting anything done today!!!!)
Thanks so very very much everyone,
Keelin
=1+SUMPRODUCT(('DATA MERGE'!$D:$D=Sheet2!$E$6)*('DATA MERGE'!$F:$F<Sheet2!$E$11))
This works
Related post : Index Match Array Multiple Criteria
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks