Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-28-2018, 04:46 AM
DBenz DBenz is offline auto progress number evenly between two values across empty cells ? Windows 7 64bit auto progress number evenly between two values across empty cells ? Office 2010 32bit
Advanced Beginner
auto progress number evenly between two values across empty cells ?
 
Join Date: Dec 2014
Posts: 69
DBenz is on a distinguished road
Default

Hi,
that does it, and I would need that between the actual two times in col A.
I didnt realise though that the formulation for calculating the increment between two times in A1 and A6, a 5 cell progression was so 'overwhelming'.
I have lots of these time gaps of varying cell gaps and I see copy paste of that formula in C1 works for any gaps now.
Is it necessary to have a new column for times, as all cells have to have the formula in I imagine so. I will collapse up column A afterwards, or I could paste value into another column and nuke A and C !
I typed out the long formula with { } and nothing worked, a friend said remove the { } and then go ctrl shift enter, then it worked , after formatting the cells as time.

I had hoped Excel would have had a menu choice of even progression between two selected values.

Thanks

DBenz
Reply With Quote
 



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 progress number evenly between two values across empty cells ? Auto populate & auto calculate values from other sections in the same word document Frantic Word VBA 2 01-24-2015 04:54 PM
auto progress number evenly between two values across empty cells ? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft