I have attached an excel with an example of what I want to do.
gthanks you
I have attached an excel with an example of what I want to do.
gthanks you
Last edited by mecexcel; 11-16-2015 at 10:37 PM.
This looks a duplicated post to me.
If so, read the forumrules about duplicated post.
http://www.excelforum.com/excel-form...nd-9000-a.html
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
Personally I'd use a Pivot Table and avoid the need for formulae at all.
See attached. The PT is based on the OPEID sheet which has been extended by two columns to sum thne values from the Scorecard. Yuo could of course do it the other way round and populate the Scorecard with the Sector from the OPEID sheet.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks