Help with countif(s)?

[leanheart]

Hello, I am trying to return a 1/0 only the first time a person exceeded 5000 in a span of several months. For example, the person in A2 exceeded 5000 every month, but I only want to know the first time they did it. Thanks for any help you can provide.

Jan Hoodies.csv.xlsx
	A	B	C	D	E	F	G	H
1	DealerID	Jan	feb	mar	apr	May	Jun	Jul
2	817829	4117	9040	13039.7	8483.63	8238	10610	7163.5
3	1355	14021	8222	15007.9	12276.5	21753.5	20362.95	16914
4	4181	2579	7882	10287.68	4553	9809	6595	5065
5	3174	2799	7545	14073.88	3701	6837	3615	1176
Jan Hoodies

Cell Formulas
Range	Formula
E2:E5	E2	=VLOOKUP(A2,'C:\Users\JohnFrank\OneDrive - Tiber River Naturals Inc\Desktop\[Apr Hoodies.csv]Apr Hoodies'!$A$1:$E$1007,5,FALSE)

 

[Toadstool]

Hi Leanheart,

Does this work for you?

LeanHeart.xlsx
	A	B	C	D	E	F	G	H	I	J
1	DealerID	Jan	feb	mar	apr	May	Jun	Jul		First Over 5000
2	817829	4117	9040	13039.7	8483.63	8238	10610	7163.5		9040
3	1355	14021	8222	15007.9	12276.5	21753.5	20362.95	16914		14021
4	4181	2579	7882	10287.68	4553	9809	6595	5065		7882
5	3174	2799	7545	14073.88	3701	6837	3615	1176		7545
Sheet1

Cell Formulas
Range	Formula
J2:J5	J2	=INDEX($B2:$H2,AGGREGATE(15,6,COLUMN($B$1:$H$1)-COLUMN($A$1)/($B2:$H2>5000),1))

 

[Fluff]

Hi & welcome to MrExcel.
Another option

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	DealerID	Jan	feb	mar	apr	May	Jun	Jul
2	817829	4117	9040	13039.7	8483.63	8238	10610	7163.5		feb
3	1355	14021	8222	15007.9	12276.5	21753.5	20362.95	16914		Jan
4	4181	2579	7882	10287.68	4553	9809	6595	5065		feb
5	3174	2799	7545	14073.88	3701	6837	3615	1176		feb
Lists

Cell Formulas
Range	Formula
J2:J5	J2	=INDEX(FILTER($B$1:$H$1,B2:H2>5000),1)

 

[leanheart]

Hi & welcome to MrExcel.
Another option

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	DealerID	Jan	feb	mar	apr	May	Jun	Jul
2	817829	4117	9040	13039.7	8483.63	8238	10610	7163.5		feb
3	1355	14021	8222	15007.9	12276.5	21753.5	20362.95	16914		Jan
4	4181	2579	7882	10287.68	4553	9809	6595	5065		feb
5	3174	2799	7545	14073.88	3701	6837	3615	1176		feb
Lists

Cell Formulas
Range	Formula
J2:J5	J2	=INDEX(FILTER($B$1:$H$1,B2:H2>5000),1)

Thank you so much for your fast response! This definitely is what I needed.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[leanheart]

Hi Leanheart,

Does this work for you?

LeanHeart.xlsx
	A	B	C	D	E	F	G	H	I	J
1	DealerID	Jan	feb	mar	apr	May	Jun	Jul		First Over 5000
2	817829	4117	9040	13039.7	8483.63	8238	10610	7163.5		9040
3	1355	14021	8222	15007.9	12276.5	21753.5	20362.95	16914		14021
4	4181	2579	7882	10287.68	4553	9809	6595	5065		7882
5	3174	2799	7545	14073.88	3701	6837	3615	1176		7545
Sheet1

Cell Formulas
Range	Formula
J2:J5	J2	=INDEX($B2:$H2,AGGREGATE(15,6,COLUMN($B$1:$H$1)-COLUMN($A$1)/($B2:$H2>5000),1))

Thanks for your help! I appreciate it greatly!