Plz help me w/ "GROWTH" function. My data in rows not columns

J

JE McGimpsey

Without knowing what you're trying to accomplish, it's hard to take a
guess, but perhaps:

Assume your known y's are in A1:J1
Assume your known x's are in A2:J2

Assume your new x's are in A3:F3

Then select A4:F4 and array-enter

=GROWTH(A1:J1,A2:J2,A3:F3)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plz help me w/ "GROWTH" function. My data in rows not columns 0
Help to display chosen columns and rows 1
remove duplicate rows from specific data in a column; excel 2007 1
Help with Sum if (or something else not sure) 4
Adding a row to worksheet does not update cell references in another. 5
I need some changes in a code 5
Restricted value sequences in rows 11
Help w/complex Due Date Function 11

Top