Copy cell value to next unused cell in another column

artz

Well-known Member
Joined
Aug 11, 2002
Messages
811
Office Version
  1. 2016
Platform
  1. Windows
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
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
77,489
Office Version
  1. 365
Platform
  1. Windows
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.
 
Solution

artz

Well-known Member
Joined
Aug 11, 2002
Messages
811
Office Version
  1. 2016
Platform
  1. Windows
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
 

Forum statistics

Threads
1,175,457
Messages
5,897,533
Members
434,660
Latest member
Stoyf

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top