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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Plz help me w/ "GROWTH" function. My data in rows not columns (https://www.excelbanter.com/excel-worksheet-functions/132995-plz-help-me-w-growth-function-my-data-rows-not-columns.html)

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

JE McGimpsey

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

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)

All times are GMT +1. The time now is 05:32 AM.