Alexis0901
New Member
- Joined
- Nov 1, 2019
- Messages
- 2
I am hoping to find a formula to automatically number a large amount of data. I need to send individual invoices to each vendor and the transactions need to be grouped by date and listed on separate lines. I have a column with the invoice identifiers and a column with the transaction dates. I built an invoice in excel that uses sumif statements to pull the necessary data from another sheet but I need an invoice line identifier to know how many lines there will need to be on each invoice. Please see example of what I'm looking for below. The "Date count per invoice" is the column I'm hoping to automate.
<tbody>
</tbody>
Any help would be appreciated.
Thanks,
Alexis
Vendor | Invoice Number | Date | Date count per invoice |
A0001 | 1 | 10/1/2019 | 1 |
A0001 | 1 | 10/1/2019 | 1 |
A0001 | 1 | 10/1/2019 | 1 |
A0001 | 1 | 10/5/2019 | 2 |
A0001 | 1 | 10/11/2019 | 3 |
A0001 | 1 | 10/19/2019 | 4 |
A0002 | 2 | 10/3/2019 | 1 |
A0002 | 2 | 10/3/2019 | 1 |
A0002 | 2 | 10/3/2019 | 1 |
A0002 | 2 | 10/15/2019 | 2 |
A0002 | 2 | 10/16/2019 | 3 |
A0003 | 3 | 9/1/2019 | 1 |
A0003 | 3 | 9/1/2019 | 1 |
A0003 | 3 | 9/15/2019 | 2 |
A0003 | 3 | 9/30/2019 | 3 |
A0003 | 3 | 10/3/2019 | 4 |
A0003 | 3 | 9/1/2019 | 1 |
A0003 | 3 | 10/10/2019 | 5 |
A0003 | 3 | 10/10/2019 | 5 |
A0003 | 3 | 10/20/2019 | 6 |
A0003 | 3 | 10/21/2019 | 7 |
A0004 | 4 | 10/17/2019 | 1 |
A0004 | 4 | 10/18/2019 | 2 |
A0004 | 4 | 10/19/2019 | 3 |
A0004 | 4 | 10/20/2019 | 4 |
<tbody>
</tbody>
Any help would be appreciated.
Thanks,
Alexis