Summary Table

[jedilefty]

Hello everyone. I need some help with a formula. I have a table with multiple columns and from this I am creating a summary table. I need help with pulling the "$ Value" from the previous day into the summary table. So today is 3/5 and I want to pull yesterday's value, and so forth.


Data Table:

Date:	$ Value	Product Average	Finish Average
3/1	$125,650.56
3/2	$225,025.65
3/3	$175,805.79
3/4	$210,208.98

Summary Table:

Values:	$ Value
Prior Day:

 

[AhoyNC]

If your dates are actual dates try:

Book1
	A	B	C	D
1
2	Date:	$ Value	Product Average	Finish Average
3	3/1	$125,650.56
4	3/2	$225,025.65
5	3/3	$175,805.79
6	3/4	$210,208.98
7
8	Prior Day	$210,208.98
Sheet2

Cell Formulas
Range	Formula
B8	B8	=FILTER(B3:B6,TODAY()-1=A3:A6,"No Data")

 

[jedilefty]

If your dates are actual dates try:

Book1
	A	B	C	D
1
2	Date:	$ Value	Product Average	Finish Average
3	3/1	$125,650.56
4	3/2	$225,025.65
5	3/3	$175,805.79
6	3/4	$210,208.98
7
8	Prior Day	$210,208.98
Sheet2

Cell Formulas
Range	Formula
B8	B8	=FILTER(B3:B6,TODAY()-1=A3:A6,"No Data")

Thank you!! This worked!!

 

[AhoyNC]

You're welcome. Thanks for the feedback.