Power Interest Matrix in columns

[MistaP73]

I have a spread sheet that I'm using for a Stakeholder Analysis and Management Plan.

I'd like to be able to incorporate a power/interest matrix in to the plan.

Is it possible to have the value of column C set to be subject to the values in columns A & B?

I'm sure it can be done, but I can't work out how to make it work.

Hope someone can help.

Power Interest Matrix xls.jpg

[cbatrody]

Hi,

Try the following formula in C2:

Please Login or Register  to view this content.

[rajeshturaha]

Plz clarify your requirement with examples, so that it is better understood and formulated

[MistaP73]

That was quick. Perfect! It worked beautifully.

Many thanks.

[cbatrody]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.

[MistaP73]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

Also, you can directly thank those who have helped you by clicking on the small * (star) icon located in the lower left corner of a post that you have found to be helpful.

Done. Thanks again.

[pmcleod]

this is a nice excel book. thanks to whomever loaded it. I would like to know if anyone plotted the results in the xy scatter diagram that makes up the power/influance model.

[MistaP73]

this is a nice excel book. thanks to whomever loaded it. I would like to know if anyone plotted the results in the xy scatter diagram that makes up the power/influance model.

Now that woukd be interesting to see!