Hello WesleyGoodwin-6831 - Use the Offset Function as per Formula described in Cell H2 - Sheet1 in the attached file.. Formula would be like below =IFERROR(IF((OFFSET('Trim Summary'!$H2,0,H$1,1,1))*100<101,REPT(CHAR(10),((OFFSET('Trim Summary'!$H2,0,H$1,1,1))*100)/4)&CHAR(10)&(OFFSET('Trim Summary'!$H2,0,H$1,1,1))*100&"%"&" "&TEXT((OFFSET('Trim Summary'!$H2,0,H$1-1,1,1)),"MMM-DD"),"?"),"NA")
Hello WesleyGoodwin-6831 - Use the Offset Function as per Formula described in Cell H2 - Sheet1 in the attached file.. Formula would be like below =IFERROR(IF((OFFSET('Trim Summary'!$H2,0,H$1,1,1))*100<101,REPT(CHAR(10),((OFFSET('Trim Summary'!$H2,0,H$1,1,1))*100)/4)&CHAR(10)&(OFFSET('Trim Summary'!$H2,0,H$1,1,1))*100&"%"&" "&TEXT((OFFSET('Trim Summary'!$H2,0,H$1-1,1,1)),"MMM-DD"),"?"),"NA")
13508-temp-for-sharing.pdf