XLS quickie

Quickie xls trick:

one sheet with info in columns, need to extract info from one column to copy (manually):
– sheet 1: add column behind column that contains info
– add new sheet (sheet 2), in which you add the info that needs to be checked for comparison with column sheet 1
– add function to first field in sheet 1: =COUNTIF(‘NAMEOFSHEET’!A:A;G2), where NAMEOFSHEET is the name of sheet 2, A:A is first field of first column of sheet 2, G2 is first field of column of sheet 1 which contains the info