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!
Posts by Estevaoba
-
-
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!
-
=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!
-
You're welcome. Thanks for the feedback.
-
Maybe:
Code=IF(MOD((A2-B2)*24,1)<0.5,INT((A2-B2)*24),INT((A2-B2)*24)+1)Good luck!