GPT instructions + excel

Question

Hello,

I have a list of about 2,000 and need to find some information based on instructions for gpt to find for me. I do not know how to create the formula though. My list is in column A which are name titles. My instructions can be column C1,D1,E1. I want column =gpt(A#+C1:E1)=B#.

A(title) + CDE(instructions) =B(answer)

I wrote =gpt (A2+A, C1:E1) which seemed to work when it's place in B2 but it it's all in cell B2. I need the answers to apply down column B to each row based on the column A(title). So A2 corresponds to B2, A3 to B3, etc.

How do I adjust the formula for this to happen?

Thank you

Answer 1

Sorry for the intrusion, but what exactly are you trying to do? GPT is not and Excel function. At least not in my version.

Formulas like: =GPT(A3&" "&C1&" "&D1&" "&E1) and =GPT(A2+A, C1:E1) are nonsense.

It would be more helpful if you could upload a screenshot showing the row and column headers, the data you work with and the expected results.

Answer 2

I did the drag to fill correctly. But when I paste and change the A column # manually it seems to work.

But I have an idea for a work around. If I were to make a new spreadsheet and place the formula gpt(A2&" "&C1&" "&D1&" "&E1) in cell A1(removed the = so the formula wouldn't apply, I can format cells later), what formula can I use to make the A# change down the column from A2:A2000 or how ever many cells I paste into?

Thanks

Answer 3

hmmm, it's also possible that the formula is not being copied down correctly.

Try to make sure that you are copying the formula down to the correct range of cells in column B. You can select cell B2, then drag the fill handle (the small square in the bottom-right corner of the cell) down to the last cell in the range where you want the formula to be applied.

Also, the references in the formula are being adjusted correctly as you copy it down. For example, if you copy the formula down to cell B3, the formula should automatically update to refer to cell A3 in the formula (i.e., =gpt(A3&" "&C1&" "&D1&" "&E1)). If still not working, I guess this is out of my scope.

Answer 4

Hey Leon,

Thanks for the reply. I used the formula you provided but after working for the first cell (A2) it does not follow the instructions for the next cells down(A3, A4, etc).

I am thinking gpt and excel aren't working correctly just yet.

Answer 5

Hello, I am Leonielhou, an Independent Advisor and a user like you, I am happy to help clarify any questions you may have.

use a relative reference to the title in column A.

=gpt(A2&" "&C1&" "&D1&" "&E1)

copy this formula down to apply it to each row in column B. When you copy the formula down, the relative reference to cell A2 will adjust to refer to the corresponding cell in column A for each row. For example, when you copy the formula down to cell B3, the formula will automatically update to:

=gpt(A3&" "&C1&" "&D1&" "&E1)

it will generate an answer based on the title in cell A3 and the instructions in cells C1, D1, and E1.