Moving average in table with non-numeric data

[Reboshua]

Need some expert help, please. As you can see below, the formula in cell c13 is an array that calculates a 12-day moving average for that data in column B. You can also see that column B has non-numeric data, which is why I'm using the array in C.

Here's my problem. I want the formula in column C to be part of the table so that it (and its associated charts on other tabs) auto-update when I add the next day's worth of data.

Any ideas? (Right now, the formula in C13 is just copied down, the table isn't automatically filling in that formula for me, presumably because I didn't create the formula in C2 (because it's a 12-day moving average).

Happy to clarify more...and thank you in advance for your help.

Unknown

	A	B	C
Date2	ARI	ARI2

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]42099[/TD]
[TD="align: right"]#DIV/0![/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]42100[/TD]
[TD="align: right"] 6.91[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]42101[/TD]
[TD="align: right"] 14.86[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]42102[/TD]
[TD="align: right"] 4.24[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]42103[/TD]
[TD="align: right"]#DIV/0![/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]42104[/TD]
[TD="align: right"] 7.45[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]42105[/TD]
[TD="align: right"] 10.65[/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]42106[/TD]
[TD="align: right"] 6.24[/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]42107[/TD]
[TD="align: right"] 14.86[/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]42108[/TD]
[TD="align: right"] 3.84[/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]42109[/TD]
[TD="align: right"] 7.68[/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]42110[/TD]
[TD="align: right"] 15.99[/TD]
[TD="align: right"] 9.27[/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]42111[/TD]
[TD="align: right"] 17.14[/TD]
[TD="align: right"] 9.99[/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]42112[/TD]
[TD="align: right"] 5.34[/TD]
[TD="align: right"] 9.84[/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]42113[/TD]
[TD="align: right"] 10.19[/TD]
[TD="align: right"] 9.42[/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]42114[/TD]
[TD="align: right"]#DIV/0![/TD]
[TD="align: right"] 9.94[/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]42115[/TD]
[TD="align: right"] 3.84[/TD]
[TD="align: right"] 9.38[/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]42116[/TD]
[TD="align: right"] 12.95[/TD]
[TD="align: right"] 9.88[/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]42117[/TD]
[TD="align: right"]#DIV/0![/TD]
[TD="align: right"] 9.81[/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A2[/TH]
[TD="align: left"]=TEXT(TeamMA!$A2,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B2[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A2,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A3[/TH]
[TD="align: left"]=TEXT(TeamMA!$A3,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B3[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A3,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A4[/TH]
[TD="align: left"]=TEXT(TeamMA!$A4,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B4[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A4,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A5[/TH]
[TD="align: left"]=TEXT(TeamMA!$A5,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B5[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A5,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A6[/TH]
[TD="align: left"]=TEXT(TeamMA!$A6,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B6[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A6,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A7[/TH]
[TD="align: left"]=TEXT(TeamMA!$A7,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B7[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A7,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A8[/TH]
[TD="align: left"]=TEXT(TeamMA!$A8,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B8[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A8,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A9[/TH]
[TD="align: left"]=TEXT(TeamMA!$A9,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B9[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A9,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A10[/TH]
[TD="align: left"]=TEXT(TeamMA!$A10,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B10[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A10,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A11[/TH]
[TD="align: left"]=TEXT(TeamMA!$A11,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B11[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A11,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A12[/TH]
[TD="align: left"]=TEXT(TeamMA!$A12,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B12[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A12,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A13[/TH]
[TD="align: left"]=TEXT(TeamMA!$A13,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B13[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A13,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A14[/TH]
[TD="align: left"]=TEXT(TeamMA!$A14,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B14[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A14,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A15[/TH]
[TD="align: left"]=TEXT(TeamMA!$A15,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B15[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A15,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A16[/TH]
[TD="align: left"]=TEXT(TeamMA!$A16,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B16[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A16,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A17[/TH]
[TD="align: left"]=TEXT(TeamMA!$A17,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B17[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A17,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A18[/TH]
[TD="align: left"]=TEXT(TeamMA!$A18,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B18[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A18,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A19[/TH]
[TD="align: left"]=TEXT(TeamMA!$A19,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B19[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A19,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]A20[/TH]
[TD="align: left"]=TEXT(TeamMA!$A20,"0000\/00\/00")+0[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B20[/TH]
[TD="align: left"]=AVERAGEIFS('DataByDate-H'!$AJ:$AJ,'DataByDate-H'!$G:$G,TeamMA!$A20,'DataByDate-H'!$H:$H,B$1)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C13[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B2:B13),B2:B13))}[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C14[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B3:B14),B3:B14))}[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C15[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B4:B15),B4:B15))}[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C16[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B5:B16),B5:B16))}[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C17[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B6:B17),B6:B17))}[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C18[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B7:B18),B7:B18))}[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C19[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B8:B19),B8:B19))}[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C20[/TH]
[TD="align: left"]{=AVERAGE(IF(ISNUMBER(B9:B20),B9:B20))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

1st I would fix the formula that is generating the error, maybe something like =if(A2="","",your-formula)
2nd, try this instead of that array formula...
C2=IF(OR(A2="",COUNTA($A$2:A2)<12),"",AVERAGEIFS(B:B,A:A,"<="&A2,A:A,">="&A2-$D$1))
copied down way past your data

 

[Peter_SSs]

I want the formula in column C to be part of the table so that it (and its associated charts on other tabs) auto-update when I add the next day's worth of data.

Any ideas? (Right now, the formula in C13 is just copied down, the table isn't automatically filling in that formula for me, presumably because I didn't create the formula in C2 (because it's a 12-day moving average).

Posting tip: When using one of the HTML makers to post a section of your sheet, look for options to limit what formulas are displayed - like mine below. Doing so means that you are not filling up large amounts of space with repeated formulas which make your post and the thread harder to read & navigate.

Anyway, try this in cell C2 of your table. It should allow the flash fill and auto-fill as you extend the table.

Excel Workbook
	A	B	C
1	Date2	ARI	ARI2
2	42099	#DIV/0!
3	42100	6.91
4	42101	14.86
5	42102	4.24
6	42103	#DIV/0!
7	42104	7.45
8	42105	10.65
9	42106	6.24
10	42107	14.86
11	42108	3.84
12	42109	7.68
13	42110	15.99	9.27
14	42111	17.14	9.99
15	42112	5.34	9.84
16	42113	10.19	9.42
17	42114	#DIV/0!	9.94
18	42115	3.84	9.38
19	42116	12.95	9.88
20	42117	#DIV/0!	9.81
21
Moving average

 

[FDibbins]

Peter, do you know if there is any advantage to be gained by using ROWS() instead of COUNTA() (just curious, I have always used COUNTA(), never thought really to use ROWS() )

 

[Peter_SSs]

Peter, do you know if there is any advantage to be gained by using ROWS() instead of COUNTA() (just curious, I have always used COUNTA(), never thought really to use ROWS() )

Hi Ford
I can think of 3 reasons for using ROWS() instead of COUNTA()
1. Speed of calculation. Relevant if the data is large. Just did a test with 20,000 rows of these functions COUNTA about 0.8 seconds, ROWS about 0.008 seconds.
2. ROWS would work on the data in column B in this thread even if there was no data in column A whereas COUNTA wouldn't (as far as I can see)
3. It's shorter to type.

 

[Reboshua]

Thank you for the great response. I learned a new function today - aggregate!

I'll post more carefully in the future.

Cheers!

 

[Peter_SSs]

Thank you for the great response. I learned a new function today - aggregate!

I'll post more carefully in the future.

Cheers!

You are very welcome.

 

[FDibbins]

Hi Ford
I can think of 3 reasons for using ROWS() instead of COUNTA()
1. Speed of calculation. Relevant if the data is large. Just did a test with 20,000 rows of these functions COUNTA about 0.8 seconds, ROWS about 0.008 seconds.
2. ROWS would work on the data in column B in this thread even if there was no data in column A whereas COUNTA wouldn't (as far as I can see)
3. It's shorter to type.

Peter, thanks for that. That was exactly the type of answer I was hoping for. Many times, different functions are used purely based on preference, but sometimes, there is a constructive reason to use 1 over another.