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,
Please, attached is an example of data which I need to transpose and a pivot
table doesn't do it...
Thank you for your help.
John
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
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
