1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel - Combining Date and Non-Date Columns

Discussion in 'Business Applications' started by BratDawg, Jan 6, 2019.

  1. BratDawg

    BratDawg Thread Starter

    Joined:
    Sep 23, 2004
    Messages:
    667
    First Name:
    Carla
    I have a spreadsheet of all my vouchers for the year. I want to sort by date, then voucher and subtotal at each change in voucher number. I want to be able to roll that up so that both the date and the voucher number show next to the subtotal so I have a summary sheet to refer to (it's a lot of lines!!! not worth printing out the whole thing).

    Is there a way to format that so that the date pulls as it appears and doesn't get converted from 7/1/17 to 4256 or something like that? I want to insert a COLUMN on the following table that =A2&" - "&e2 to pulls the voucher date and the voucher number showing "7/15/2016 - 2001" next the subtotal for the voucher when it's rolled up. It's showing "42566 - 2001".

    VoucherDate TFundDescription TFund Amount Voucher
    7/15/2016 IDEA, PART B 1220 1,345.23 2001
    7/15/2016 IDEA, PART B 1220 1,000.00 2001
    7/15/2016 FACULTY HOUSING 1293 452.42 2001
    7/15/2016 ADMINISTRATION 1285 4,030.64 2001

    Thanks guys!
    Carla
     
  2. etaf

    etaf Moderator

    Joined:
    Oct 2, 2003
    Messages:
    64,879
    First Name:
    Wayne
    sample spreadsheet attached may help
    if data is formated OK, then a simple Table of data and a pivot table would work - so after you have emntered the new data , all you do is refresh the subtotal will appear, I'm assuming this is the subtotal of the value of the voucher ??
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...

Short URL to this thread: https://techguy.org/1221509

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice