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