Test to columns help please Estevaoba July 1, 2022 at 9:51 PM Copy across and down: Code =TRIM(MID(SUBSTITUTE($A1,", ",REPT(" ",LEN($A1))),(COLUMNS($A$1:A$1)-1)*LEN($A1)+1, LEN($A1))) Good luck!

Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows Estevaoba November 4, 2021 at 2:43 PM Maybe Code =IFERROR(IF(OR(VLOOKUP(A2,'Stock Provision'!$A:$B,2,0)=SUMIF(A$2:A2,A2,D$2:D2),VLOOKUP(A2,'Stock Provision'!$A:$B,2,0)>SUMIF(A$2:A2,A2,D$2:D2)),D2,IF(VLOOKUP(A2,'Stock Provision'!$A:$B,2,0)<SUMIF(A$2:A2,A2,D$2:D2),VLOOKUP(A2,'Stock Provision'!$A:$B,2,0),0)),"") Good luck!

MAX date with conditions Estevaoba November 4, 2021 at 1:47 PM =IF(AND(COUNTIF(B3:B15,D3)>COUNTIF(B3:B15,D4),MIN(IF(B3:B15=D3,A3:A15))>MAX(IF(B3:B15=D4,A3:A15))),D3,D4) Good luck!

Round Time up Estevaoba October 5, 2020 at 3:34 AM Maybe: Code =IF(MOD((A2-B2)*24,1)<0.5,INT((A2-B2)*24),INT((A2-B2)*24)+1) Good luck!