m.susanto

hi all... how to highlighted cell with red if : if in name contains first word "s"---so highlighted with red in adjacent cell (in col.cf) <tbody> name cf saluran terbuka #FF0000[/URL] , align: right"] saluran tertutup #FF0000[/URL] , align: right"] </tbody> m.susanto

hi all... how to sequential numbering like this : 1 1 2 2 3 3 etc.. any help...thanks so much m.susanto

hi all... how to distribute this data below : Excel 2007 32 bit DEF 2data1data2expected result 3707070 418045180 54545 64545 74545 815238152 93838 Sheet: Sheet1 any helps much appreciated... m.susanto

hi all... how to solve this problem : Book1ABC1DATAFORMULAAFTER FORMULA2B19B19B0193H6H06H0064H326H0326H3265A1A01A001Sheet1Cell FormulasCellFormulaB2=IF(LEN(A2)=3,A2,REPLACE(A2,2,,0))B3=IF(LEN(A3)=3,A3,REPLACE(A3,2,,0))B4=IF(LEN(A4)=3,A4,REPLACE(A4,2,,0))B5=IF(LEN(A5)=3,A5,REPLACE(A5,2,,0))...

hi all.. how to find matching value from intervals, like this layout : Excel 2007DEFG5pointmodelmodelmodel612370-1910977820-39121486940-5915564510>=60252321111213lookup/expected result14point (given)model (given)result1572?Sheet1 any help is greatly appreciated... m.susanto

hello all.. how to make this below code it works : =char(code(e11)+1) a cross post https://www.excelforum.com/excel-formulas-and-functions/1208807-fill-alphabetic-series-with-interval-row.html any helps is greatly appreciated. m.susanto

hi all.... how to data counting without helper column this layout : Excel 2007 <colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=E0E0F0"" target="_blank"></colgroup><colgroup><col><col></colgroup><thead> A B </thead><tbody> 1...