STDEV(i),
Excellent! Works like a charm. If I would like to add a formula to the
total column, that would only pick up only the Order Qty amount, how would I
do that? (the order number is a six digit number and adds to the total) I
would use =SUMIF(A$25:Z$25,"Order Qty",A26:Z26) after the fact,
Dear Mr. Smith,
Please try and check this VBA Code, if it helps...
Sub AbnormalizeYourTabel()
' STDEV(i) / milis belajar-excel / 08 apr 2011
' retouched for another table-structure
' jakarta, Jun 12, 2011
'---
Dim Tbl As Range, NewTbl A