Display the number of week when the value goes below 0

[venrous]

Hello!

I am trying to make my work easier but cannot find the right formula to meet my criteria.
I would like to extract the number of week number when the value from row 2 goes below 0 and put it in cell E2.

In the example down below it is going to be 2022_w50 with -48 pieces. How can I put this demand into an excel formula?

test_formulki.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	SKU	NAME	SUPPLIER	Stockout - when?	2022_w42	2022_w43	2022_w44	2022_w45	2022_w46	2022_w47	2022_w48	2022_w49	2022_w50	2022_w51	2022_w52	2023_w01	2023_w02	2023_w03	2023_w04	2023_w05
2	Item number	Item A	Supplier		1 193	1 113	995	652	534	415	243	98	-48	-193	-330	-417	-505	-593	-680	-781
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2:U2	Cell Value	<0	text	NO
F2:U2	Expression	=F2<#REF!	text	NO

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TAKE(FILTER($F$1:$U$1,F2:U2<0),,1)

 

[venrous]

This formula works like a charm, however, it spills all the weeks with minus values. How can I limit it to just receiving the first week with a negative value?

 

[Fluff]

It does just return the 1st week

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1		SKU	NAME	SUPPLIER	Stockout - when?	2022_w42	2022_w43	2022_w44	2022_w45	2022_w46	2022_w47	2022_w48	2022_w49	2022_w50	2022_w51	2022_w52	2023_w01	2023_w02	2023_w03	2023_w04	2023_w05
2		Item number	Item A	Supplier	2022_w50	1193	1113	995.36129	652.36129	533.594624	414.82796	242.82796	97.634409	-47.5591398	-192.752688	-329.72043	-417.333333	-504.946237	-592.55914	-680.17204	-781.27573
Data

Cell Formulas
Range	Formula
E2	E2	=TAKE(FILTER($F$1:$U$1,F2:U2<0),,1)