What is the best solution to this excel question?

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

retropete

New Member
Joined
Jan 27, 2014
Messages
8
Thanks for the help Jack. I had a read of the link and then further reading into SUMPRODUCT but i still can't seem to answer the question..i mean i can answer the question but it just seems as if there is a much easier more efficient way of doing it.

Still open for ideas...

Thanks guys
 

Watch MrExcel Video

Forum statistics

Threads
1,113,978
Messages
5,545,308
Members
410,675
Latest member
DLongmountain
Top