Help with multiple Formulas in one

[vonmunchy]

Hi,
sdsdsd.JPG

I attached the sheet and a picture as well. I would like help with building the formula for Colum G ("Result") and Colum H ("ID Number")

Colum G is is filtered result of Colum F and Colum E. I entered the formulas for Colum F and Colum E but manually wrote the results for Colum G and Colum H.

I only want those specific results to appear and all other to be ignored. A Spill formula would be very helpful in getting the job done within a single cell.

Thank you. Hope my explanation was clear enough.

[Bo_Ry]

Please try
G
=LET(f,F2:F34,IF(ABS(f)=1,MID(E2:E34,3,9)&IF(f=1," Plus"," Minus"),""))

H
=IF(I2#="","",C2:C34&","&C3:C35)