Results 1 to 6 of 6

Centering data in one column between two adjacent rows

Threaded View

gallagt01 Centering data in one column... 04-13-2017, 10:29 AM
JeteMc Re: Centering data in one... 04-13-2017, 11:05 AM
gallagt01 Re: Centering data in one... 04-13-2017, 11:18 AM
JeteMc Re: Centering data in one... 04-13-2017, 02:12 PM
gallagt01 Re: Centering data in one... 04-18-2017, 10:16 AM
JeteMc Re: Centering data in one... 04-18-2017, 11:12 AM
  1. #1
    Registered User
    Join Date
    04-10-2017
    Location
    New York
    MS-Off Ver
    2010
    Posts
    19

    Centering data in one column between two adjacent rows

    Hello,

    I'm wondering if it's possible to center data in one column between two adjacent rows without simply merging/centering two cells in one column.

    Here is a picture of what exactly I'm looking to do.

    20170413_095615.jpg

    My company wants to document machine hours every time we change that machine's "tooling."

    I wrote into the cells in the "elapsed" column the correct formula to automatically generate how many hours elapsed between each "tooling change" (so when I enter a new "date of tooling change" and the machine hours at the time of the change, the amount of time that elapsed after the previous tooling change is displayed).

    But I want that information be centered between the hours of the tooling change, much like how I have it in the first two rows in the above picture (which I did by merging and centering the cells in the elapsed column). I want the "19" in my elapsed column to center between the 81 and the 100, etc etc. It doesn't seem possible to center the subsequent elapsed data unless I duplicate rows and merge/center accordingly (as seen in the bottom chart in the above picture), though.

    Any help on this would be much appreciated. Thank you!
    Last edited by gallagt01; 04-13-2017 at 11:18 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Search one column, then rows and the return adjacent cell value
    By K8tieC in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-27-2016, 12:06 AM
  2. VBA to autofill formula row down to other rows where adjacent column is populated
    By jamesr86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-14-2016, 02:03 AM
  3. Centering across ROWS without merging
    By francisvachon in forum Excel General
    Replies: 5
    Last Post: 04-07-2015, 06:37 PM
  4. Macro that cuts data from lower rows and pastes them in adjacent rows
    By kehl_4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 02:07 PM
  5. VBA to add one column by all values of the adjacent 8 columns and three rows once each
    By amweisberg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-16-2014, 07:48 AM
  6. Selecting n rows in the adjacent column
    By Sathed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2012, 07:20 PM
  7. Replies: 1
    Last Post: 11-16-2011, 02:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1