Highest value since

[mejh1984]

I have weekly sales data in one row, with the weekending date in the row above. When I look at last week's sales for example, I want to know how many weeks it's been since the sales were higher than last week (and preferably what week this was). Is there a formula that can tell me this?

 

[Peter_SSs]

Without sample data and expected results it is a bit hard to know exactly where you are measuring your dates/weeks from, but see if any of this might get you started.

For the future, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

23 12 04.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
2	Week	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13
3	Week Ending	1/09/2023	8/09/2023	15/09/2023	22/09/2023	29/09/2023	6/10/2023	13/10/2023	20/10/2023	27/10/2023	3/11/2023	10/11/2023	17/11/2023	24/11/2023
4	Sales	6	6	2	3	3	7	2	1	7	5	9	2	7
5	Weeks since sales higher than last week			Never	2	3	4	Never	2	2	Never	2	Never	2
6	Which week was the last with sales higher than last week?			N/A	8/09/2023	8/09/2023	8/09/2023	N/A	6/10/2023	13/10/2023	N/A	27/10/2023	N/A	10/11/2023
Sales

Cell Formulas
Range	Formula
D5:N5	D5	=IFERROR((D3-AGGREGATE(14,6,$B3:B3/($B4:B4>C4),1))/7,"Never")
D6:N6	D6	=IF(ISNUMBER(D5),D3-7*D5,"N/A")