Catch the Phillies Phever World Series 2008 Unique Collectibles and T's

Archive for the 'Excel' Category

List sorting

Wednesday, March 26th, 2008

Have you ever wanted to sort the hordes of records you have by a column and hide temporarily all others ? check out this article its good…
[ MS trackback ]

Excel Custom Formulas/Functions ]

COUNTIF

Tuesday, March 25th, 2008

A PIVOT TABLES using a dynamic range can handle some tricky problems in excel…

=COUNTIF(C2:C8,”%LIKE%”)

C2:C8 range , “what your target conditional argument is”

[vidtorial]

[ Stat Function reference ]