Excel - Combining Date and Non-Date Columns

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

BratDawg

Thread Starter
Joined
Sep 23, 2004
Messages
677
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
 

etaf

Moderator
Joined
Oct 2, 2003
Messages
65,435
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 ??
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Staff online

Top