GET Yesterdays sale price in a new column based on dates and multiple fruits criteria

[harshabatuka10]

Sorry if similar solution is posted already trying to acheive yesterday sale price in a new column. 

Fruit	Date	Sales
Apple	2/24/2021	3
Banana	2/24/2021	4
Orange	2/24/2021	6
Apple	2/23/2021	3
Banana	2/23/2021	4
Orange	2/23/2021	5
Apple	2/22/2021	6
Banana	2/22/2021	2
Orange	2/22/2021	1

 trying to acheive below ( sale price from day before on a new column)

Fruit	Date	Sales	YesterdaySales
Apple	2/24/2021	3	3
Banana	2/24/2021	4	4
Orange	2/24/2021	6	5
Apple	2/23/2021	3	6
Banana	2/23/2021	4	2
Orange	2/23/2021	5	1
Apple	2/22/2021	6	Not Available
Banana	2/22/2021	2	Not Available
Orange	2/22/2021	1	Not Available

Thanks 

[Anonymous · Accepted solution]

[harshabatuka10]

It worked. Thanks @Anonymous