Copy cell value to next unused cell in another column

[artz]

Hi,

I'm hoping that someone in the Forum has a solution for my question without using VBA. Searching the Internet, I could not find a solution that did not use VBA. What I've got is a simple worksheet that analyzes dice rolls. I'm trying to determine if a "7" is rolled more often for short dice rolls, i.e., 30-50 rolls for example.

Cell R2 determines the number of dice rolls. Cell Q7 shows the number of "7"s produced during these 30-50 rolls. Pressing the F9 key gives a new roll value. Starting in Column T, at cell T2, I'd like to fill down each new value in Q7 to the next empty cell in column T, starting in Column T, at cell T2. The idea is to get statistics from column T.

Sorry if I'm redundant; just trying to be clear. I'd really like to do this as I said initially with a cell formula and not VBA.

Could someone in the Forum provide a cell formula to do this?

Any help is greatly appreciated.

Thanks,

Art

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You cannot do that with a formula, you will either have to do it manually or with a macro.

 

[artz]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You cannot do that with a formula, you will either have to do it manually or with a macro.

Hi Fluff,
I updated my account as requested. You probably know better than me that what I am trying to do requires VBA- thanks for the tip. I'll hunt around for some suitable code.
Thanks,
Art

 

[Fluff]

I updated my account as requested.

Thanks for that

I'll hunt around for some suitable code.

If you need any further help, I'd suggest that you start a new thread.

 

[artz]

Thanks for that

If you need any further help, I'd suggest that you start a new thread.

Yup, will do.