Anyone an Excel monster here?

[Radium_Angel]

Just curious, can I make a cell with a number (say, 1 million) and have it count down automatically on a constant basis until it reaches 0?

[minibois]

Something like this perhaps:

https://www.extendoffice.com/documents/excel/2144-excel-countdown-timer.html

You could insert a number into a cell and have it be formatted as time (seconds) for this to work.

 

Or were you looking for something so you can have (in your case a million) cells, first being 1.000.000, second 999.999, etc. etc.?

[Radium_Angel]

2 hours ago, minibois said:

Or were you looking for something so you can have (in your case a million) cells, first being 1.000.000, second 999.999, etc. etc.?

Like that.

[straight_stewie]

7 minutes ago, Radium_Angel said:

Like that.

The basic way is to write a couple of numbers in the series, and then highlight the series. In the bottom of the highlighted series, there should be a little black square. You can either drag that (if doing just a few), or double click it and Excel will autofill the column.

Be aware that a million rows is ALOT . According to Microsoft the maximum amount of rows ever possible is 1,048,576.
 

[WWicket]

3 hours ago, straight_stewie said:

Be aware that a million rows is ALOT . According to Microsoft the maximum amount of rows ever possible is 1,048,576.
 

This. If you are actually dealing with a million rows, there are better options than excel. 

[Radium_Angel]

14 hours ago, straight_stewie said:

The basic way is to write a couple of numbers in the series, and then highlight the series. In the bottom of the highlighted series, there should be a little black square. You can either drag that (if doing just a few), or double click it and Excel will autofill the column.

Be aware that a million rows is ALOT . According to Microsoft the maximum amount of rows ever possible is 1,048,576.
 

Apologies, I mis-speak. What I want is a number LIKE 1 million, occupying a single cell, that counts down by 1, at a constant rate. Like a timer..

[straight_stewie]

2 minutes ago, Radium_Angel said:

What I want is a number LIKE 1 million, occupying a single cell, that counts down by 1, at a constant rate. Like a timer..

Oh. You're going to need to do some VBA work for this. Kutools for Excel contains a countdown timer, but it only does cells formatted as time. Kutools has a license cost of $49 USD.

[bowrilla]

Basically all the logic stuff you need: https://docs.microsoft.com/de-de/office/vba/language/reference/user-interface-help/timer-function

 

And here you'll find all information to access cells and their content: https://www.quora.com/How-can-you-change-a-cell-value-using-VBA-in-Microsoft-Excel