auto progress number evenly between two values across empty cells ?

DBenz · #1 03-24-2018, 03:19 PM

Quote:

Originally Posted by xor

I don't understand what you mean.

Please show what you expect in which cells.

00:01:53

blank
blank
blank
blank
00:02:59

this would be the difference between 00:02:59 and 00:01:53 divided by 5 then added cumulatively to 00:01:53 so 00:01:06 is 66 secs /5 is 13.2 secs so add 13.2 secs on each time to form an even progression.

00:01:53
00:02:06
00:02:19
00:02:33
00:02:46
00:02:59

DBenz

xor · #2 03-24-2018, 10:42 PM

Maybe like the attached.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
If a2 is not empty, color empty cells in b2:af2	turkanet	Excel	2	08-20-2017 11:00 PM
Auto populate & auto calculate values from other sections in the same word document	Frantic	Word VBA	2	01-24-2015 04:54 PM
How to get rid of empty cells.	nicholes	Excel	7	12-23-2013 06:27 PM
How do you loop through an array with some empty values?	omahadivision	Excel Programming	5	11-28-2013 10:49 AM
Apparently empty (blank) cells aren't empty	daymaker	Excel	3	03-08-2012 03:41 PM