Sequential numbering of unique values in multiple columns

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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Welcome to the MrExcel forum.

Try:


Book1
ABCDE
1VendorInvoice NumberDateDate count per invoice
2A0001110/1/20191
3A0001110/1/20191
4A0001110/1/20191
5A0001110/5/20192
6A0001110/11/20193
7A0001110/19/20194
8A0002210/3/20191
9A0002210/3/20191
10A0002210/3/20191
11A0002210/15/20192
12A0002210/16/20193
13A000339/1/20191
14A000339/1/20191
15A000339/15/20192
16A000339/30/20193
17A0003310/3/20194
18A000339/1/201941
19A0003310/10/20195
20A0003310/10/20195
21A0003310/20/20196
22A0003310/21/20197
23A0004410/17/20191
24A0004410/18/20192
25A0004410/19/20193
26A0004410/20/20194
Sheet7
Cell Formulas
RangeFormula
D2{=SUM(SIGN(FREQUENCY(IF($A$2:$A2=A2,IF($B$2:$B2=B2,$C$2:$C2)),$C$2:$C2)))}
Press CTRL+SHIFT+ENTER to enter array formulas.


Note that row 18 varies from your example, but I believe the formula follows your request.
 
Upvote 0
Hi @Alexis0901, welcome to the forum!

Try this "regular" formula, It is a longer than the solution of Eric, but it fulfills all your requirement.

<table border="1" cellspacing="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:76.04px;" /><col style="width:94.1px;" /><col style="width:86.5px;" /><col style="width:92.2px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:37px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Vendor</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Invoice Number</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Date</td><td style="background-color:#ffff00; font-weight:bold; text-align:center; ">Date count per invoice</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >A0001</td><td style="text-align:right; ">1</td><td style="text-align:right; ">01/oct/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >A0001</td><td style="text-align:right; ">1</td><td style="text-align:right; ">01/oct/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >A0001</td><td style="text-align:right; ">1</td><td style="text-align:right; ">01/oct/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >A0001</td><td style="text-align:right; ">1</td><td style="text-align:right; ">05/oct/2019</td><td style="text-align:right; ">2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >A0001</td><td style="text-align:right; ">1</td><td style="text-align:right; ">11/oct/2019</td><td style="text-align:right; ">3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td >A0001</td><td style="text-align:right; ">1</td><td style="text-align:right; ">19/oct/2019</td><td style="text-align:right; ">4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td >A0002</td><td style="text-align:right; ">2</td><td style="text-align:right; ">03/oct/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td >A0002</td><td style="text-align:right; ">2</td><td style="text-align:right; ">03/oct/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td >A0002</td><td style="text-align:right; ">2</td><td style="text-align:right; ">03/oct/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td >A0002</td><td style="text-align:right; ">2</td><td style="text-align:right; ">15/oct/2019</td><td style="text-align:right; ">2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td >A0002</td><td style="text-align:right; ">2</td><td style="text-align:right; ">16/oct/2019</td><td style="text-align:right; ">3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">01/sep/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">01/sep/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">15/sep/2019</td><td style="text-align:right; ">2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">30/sep/2019</td><td style="text-align:right; ">3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">03/oct/2019</td><td style="text-align:right; ">4</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">01/sep/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">10/oct/2019</td><td style="text-align:right; ">5</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">10/oct/2019</td><td style="text-align:right; ">5</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">20/oct/2019</td><td style="text-align:right; ">6</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td >A0003</td><td style="text-align:right; ">3</td><td style="text-align:right; ">21/oct/2019</td><td style="text-align:right; ">7</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td >A0004</td><td style="text-align:right; ">4</td><td style="text-align:right; ">17/oct/2019</td><td style="text-align:right; ">1</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td >A0004</td><td style="text-align:right; ">4</td><td style="text-align:right; ">18/oct/2019</td><td style="text-align:right; ">2</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td >A0004</td><td style="text-align:right; ">4</td><td style="text-align:right; ">19/oct/2019</td><td style="text-align:right; ">3</td></tr><tr style="height:19px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td >A0004</td><td style="text-align:right; ">4</td><td style="text-align:right; ">20/oct/2019</td><td style="text-align:right; ">4</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b></b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >D2</td><td >=IFERROR(IF(COUNTIFS($A$2:A2,A2,$C$2:C2,C2)=1,SUMPRODUCT(MAX(($A1:A$2=A2)*($D1:D$2)))+1,SUMPRODUCT(MAX(($A1:A$2=A2)*($C1:C$2=C2)*($D1:D$2)))),1)</td></tr></table></td></tr></table>
 
Upvote 0
The main disadvantage to using an array formula is that you need to remember to press Control+Alt+Enter when entering it. And if you give the workbook to someone else, they may not be familiar with the concept. The advantage can be shorter formulas, and FREQUENCY formulas tend to be pretty efficient.

There are some functions which have array processing built in, such as SUMPRODUCT, AGGREGATE, or LOOKUP. As Dante correctly mentions, in this case you can write a function that does the same thing without needing to use Control+Shift+Enter. Here's a somewhat shorter SUMPRODUCT formula:

=SUMPRODUCT((A$2:A2=A2)*(B$2:B2=B2)/COUNTIFS(A$2:A2,A$2:A2,B$2:B2,B$2:B2,C$2:C2,C$2:C2))

Also, Dante, I don't see you using column B in your formula. If there are multiple invoices per vendor (which this example doesn't show, so maybe not an issue), I suspect your formula would give odd results.
 
Upvote 0
Also, Dante, I don't see you using column B in your formula. If there are multiple invoices per vendor (which this example doesn't show, so maybe not an issue), I suspect your formula would give odd results.

Thanks Eric for the comments. You are right, I did not consider column B, since it was not in the examples, but if there are multiple invoices per vendor, it is not a suspicion, my formula will surely have problems.

@Alexis0901,
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.

If you are going to fill out an invoice, perhaps the most practical is to create a macro for these purposes. The macro could automatically calculate the number of rows per invoice, among other things (Invoice counter, print, save as pdf, send by mail, save the file, generate all invoices, etc.)
 
Upvote 0
Note that row 18 varies from your example,....
I also think there is an issue with row 18 but I'm wondering if it is the sample data as much as the expected result that is in error?

Since the OP said ..
..the transactions need to be grouped by date ...
.. I read it as that is what had happened (but also grouped by vendor & invoice number) & we are just trying to identify how many rows there are per vendor per invoice per date. Could be completely wrong but if that is the case then perhaps this (after I have altered C18 so that my assumption is correct. :))

<b>Invoice</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:60px;" /><col style="width:108px;" /><col style="width:90px;" /><col style="width:155px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td><td >C</td><td >D</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="font-size:10pt; ">Vendor</td><td style="font-size:10pt; text-align:right; ">Invoice Number</td><td style="font-size:10pt; text-align:right; ">Date</td><td style="font-size:10pt; text-align:center; ">Date count per invoice</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="font-size:10pt; ">A0001</td><td style="font-size:10pt; text-align:right; ">1</td><td style="font-size:10pt; text-align:right; ">01-Oct-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="font-size:10pt; ">A0001</td><td style="font-size:10pt; text-align:right; ">1</td><td style="font-size:10pt; text-align:right; ">01-Oct-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="font-size:10pt; ">A0001</td><td style="font-size:10pt; text-align:right; ">1</td><td style="font-size:10pt; text-align:right; ">01-Oct-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="font-size:10pt; ">A0001</td><td style="font-size:10pt; text-align:right; ">1</td><td style="font-size:10pt; text-align:right; ">05-Oct-19</td><td style="font-size:10pt; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="font-size:10pt; ">A0001</td><td style="font-size:10pt; text-align:right; ">1</td><td style="font-size:10pt; text-align:right; ">11-Oct-19</td><td style="font-size:10pt; text-align:center; ">3</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="font-size:10pt; ">A0001</td><td style="font-size:10pt; text-align:right; ">1</td><td style="font-size:10pt; text-align:right; ">19-Oct-19</td><td style="font-size:10pt; text-align:center; ">4</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >8</td><td style="font-size:10pt; ">A0002</td><td style="font-size:10pt; text-align:right; ">2</td><td style="font-size:10pt; text-align:right; ">03-Oct-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="font-size:10pt; ">A0002</td><td style="font-size:10pt; text-align:right; ">2</td><td style="font-size:10pt; text-align:right; ">03-Oct-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="font-size:10pt; ">A0002</td><td style="font-size:10pt; text-align:right; ">2</td><td style="font-size:10pt; text-align:right; ">03-Oct-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="font-size:10pt; ">A0002</td><td style="font-size:10pt; text-align:right; ">2</td><td style="font-size:10pt; text-align:right; ">15-Oct-19</td><td style="font-size:10pt; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="font-size:10pt; ">A0002</td><td style="font-size:10pt; text-align:right; ">2</td><td style="font-size:10pt; text-align:right; ">16-Oct-19</td><td style="font-size:10pt; text-align:center; ">3</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >13</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">01-Sep-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >14</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">01-Sep-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >15</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">15-Sep-19</td><td style="font-size:10pt; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >16</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">30-Sep-19</td><td style="font-size:10pt; text-align:center; ">3</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >17</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">03-Oct-19</td><td style="font-size:10pt; text-align:center; ">4</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >18</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="background-color:#ffcc00; font-size:10pt; text-align:right; ">03-Oct-19</td><td style="font-size:10pt; text-align:center; ">4</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >19</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">10-Oct-19</td><td style="font-size:10pt; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >20</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">10-Oct-19</td><td style="font-size:10pt; text-align:center; ">5</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >21</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">20-Oct-19</td><td style="font-size:10pt; text-align:center; ">6</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >22</td><td style="font-size:10pt; ">A0003</td><td style="font-size:10pt; text-align:right; ">3</td><td style="font-size:10pt; text-align:right; ">21-Oct-19</td><td style="font-size:10pt; text-align:center; ">7</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >23</td><td style="font-size:10pt; ">A0004</td><td style="font-size:10pt; text-align:right; ">4</td><td style="font-size:10pt; text-align:right; ">17-Oct-19</td><td style="font-size:10pt; text-align:center; ">1</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >24</td><td style="font-size:10pt; ">A0004</td><td style="font-size:10pt; text-align:right; ">4</td><td style="font-size:10pt; text-align:right; ">18-Oct-19</td><td style="font-size:10pt; text-align:center; ">2</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >25</td><td style="font-size:10pt; ">A0004</td><td style="font-size:10pt; text-align:right; ">4</td><td style="font-size:10pt; text-align:right; ">19-Oct-19</td><td style="font-size:10pt; text-align:center; ">3</td></tr><tr style="height:21px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >26</td><td style="font-size:10pt; ">A0004</td><td style="font-size:10pt; text-align:right; ">4</td><td style="font-size:10pt; text-align:right; ">20-Oct-19</td><td style="font-size:10pt; text-align:center; ">4</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >D2</td><td >=IF(OR<span style=' color:008000; '>(A2<>A1,B2<>B1)</span>,1,N<span style=' color:008000; '>(D1)</span>+<span style=' color:008000; '>(C2<>C1)</span>)</td></tr></table></td></tr></table>
 
Upvote 0
These all work for what I need as long as I sort by vendor number and transaction date first.

Thank you so much for the help!
Alexis
 
Upvote 0
I'm glad you found a solution. Thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,215
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top