Integrating VBA to Solver

[panyagak]

hi

I need to solve this formula using Solver and vba.

Pi = Ni^k (power k)

Applied to this example:
1.51 3.69 5.30 (in columns D2, E2, F2 respectively)

Where
Ni represents (1/1.51), (1/3.69),(1/ 5.30), individually .

There are 2 competitors, n.

N = Sum of the 3 Ni(s)

k is derived as:
Log n / Log(n/N).

k is the SUBJECT
OF ITERATION to ENSURE
SUMMATION OF THE DERIVED 3 Pi=1.00.

Maximum iterations=100.

Am new to using Solver and integrating vba to it to a large Range of cells, say D2:F850

help out

regards

 

[Fluff]

Duplicate VBA Iterator

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).