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.
[TABLE="width: 394"]
<tbody>[TR]
[TD="align: center"]Vendor[/TD]
[TD="align: center"]Invoice Number[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Date count per invoice[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/5/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"] 10/11/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/19/2019[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/15/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/16/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/15/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/30/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/10/2019[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/10/2019[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/20/2019[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/21/2019[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/17/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/18/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/19/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/20/2019[/TD]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]
Any help would be appreciated.
Thanks,
Alexis
[TABLE="width: 394"]
<tbody>[TR]
[TD="align: center"]Vendor[/TD]
[TD="align: center"]Invoice Number[/TD]
[TD="align: center"]Date[/TD]
[TD="align: center"]Date count per invoice[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/5/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"] 10/11/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0001[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]10/19/2019[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/15/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0002[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]10/16/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/15/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/30/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/3/2019[/TD]
[TD="align: center"]4[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]9/1/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/10/2019[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/10/2019[/TD]
[TD="align: center"]5[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/20/2019[/TD]
[TD="align: center"]6[/TD]
[/TR]
[TR]
[TD="align: center"]A0003[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]10/21/2019[/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/17/2019[/TD]
[TD="align: center"]1[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/18/2019[/TD]
[TD="align: center"]2[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/19/2019[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]A0004[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"]10/20/2019[/TD]
[TD="align: center"]4[/TD]
[/TR]
</tbody>[/TABLE]
Any help would be appreciated.
Thanks,
Alexis