on excel

3. Using Data, Filter, Advanced, extract a list of the checks that have not cleared. These are called the outstanding checks. First, we need to create a criterion that searches for Checks that have not cleared (the contents of the cleared cell is not equal to X ). Use this text X The in combination means "not equal to" Where should this go in the criteria area? In cell I4, right below Cleared Now, we can use the advanced filter. Be sure to choose "copy to a new location" and then properly highlight the database, criterion and extract areas. Once the list of outstanding checks has been extracted we are ready to place those outstanding checks on the bank reconciliation using a macro