Sunday, February 20, 2011

Excel Tips

In an excel task if you have a csv file you must staight away go "save as" and save it as an excel file!

Formulas:
=LOOKUP(this,here) e.g. =LOOKUP(B7(cell),J8code(file the formula has been
=COUNTIF(#########################
+

1 comment: