Stumped on a simple formula. Need help

[mdean32]

What formula could I use that would locate the first numeric value for Part A,B,C, and then give the correct date in which the first numeric value was located? Example, if I wanted to know the due date of Part C, how would I get the formula to return 4/22? Part B to return 4/20? etc Thank you in advance

Part	4/18	4/19	4/20	4/21	4/22
A		2
B			3
C					5

 

[DanteAmor]

So I assume there is no way to always get the first numerical value in a row instead of the last for the above spreadsheet?

Do you want the first value greater than 0 ?
If there are more conditions it is convenient that you put the possible cases and the possible results.

Try the folowing array formula:

Dante Amor
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Material	OH Inv	Past Due	8-Apr	9-Apr	10-Apr	11-Apr	12-Apr	13-Apr	14-Apr	15-Apr	16-Apr	17-Apr	18-Apr	19-Apr	20-Apr	21-Apr	22-Apr	pd	next 5	Due Date
2	119825083M	0	60																60	0	Past Due
3	KE22207645M	0						40											40	0	12-Apr
4	116600122002M	0	9			18													27	0	Past Due
5	116600122008M	-23							23										0	23	13-Apr
6	116600122011M	23					477				500								477	500	OH Inv
Hoja12

Cell Formulas
Range	Formula
U2:U6	U2	=INDEX($B$1:$R$1,,SMALL(IF(B2:R2>0,COLUMN(B2:R2)),1)-1)
Press CTRL+SHIFT+ENTER to enter array formulas surrounded with curly braces.

 

[GraH]

So I assume there is no way to always get the first numerical value in a row instead of the last for the above spreadsheet?

You need to tweak the formula so it respects your columns (range) used.
Following new example of data it becomes =INDEX($D$1:$R$1,AGGREGATE(15,6,(COLUMN($D$1:$R$1)-3)/(D2:R2>0),1)).