Formula to bring in first two values

[Dastnai]

Hi Everyone,

I am looking for a formula to bring in the first two values in a row.

Here is my data set:

My desired outcome is the inventory during request 1 and 2

Inventory during request 1	Inventory during request 2	12/8/2018	12/9/2018	12/10/2018	12/11/2018	12/12/2018	12/13/2018	12/14/2018	12/15/2018	12/16/2018	12/17/2018	12/18/2018	12/19/2018
-56248.73725													-56248.7373
4410.2465	3790.2465	4410.2465	3790.2465	2940.2465	2090.2465	1240.2465	390.2465	-459.7535	-1309.7535	-2159.7535	-3009.7535
-5311.638	-5991.638								-5311.638	-5991.638	-6671.638	-7224.138

<tbody>
</tbody>

Thanks,

Dastnai

 

[JustynaMK]

Hi Dastnai,

Assuming that your sample data is in cells A1:N4, "Inventory during request 1" is in column A and "Inventory during request 2" is in column B, you can try using the following Array formulas (enter with Ctrl+Shift+Enter):

Cell A2 & below -> =IFERROR(INDEX(C2:N2,1,MATCH(TRUE,ISNUMBER(C2:N2),0)),"")
Cell B2 & below -> =IFERROR(INDEX(C2:N2,1,MATCH(TRUE,ISNUMBER(C2:N2),0)+1),"")

Hope it helps.