Using Advance Filter sample 2 3 4 pg 132 133 134

Example 2

To see rows of data for more than 2 accounts in ACCOUNT-DEBIT column

Say we want to view the data of 4 accounts from the column ACCOUNT-DEBIT.

In this case, we want to select four unique items from a single column. So we will use an Advanced Filter operation. This will allow us to select more than 2 unique items in a certain column.

1. Set up a criteria block to look like this:

	A				B
33
34	ACCOUNT-DEBIT
35	BANK A
36	BANK B
37	BANK C
38	BANK D
39	

132

The above setting indicates that we want to view rows where the column ACCOUNT-DEBIT contain the item BANK A, BANK B, BANK C or BANK D.

2. Follow steps 3 to 8 as in Example 1 above.

You should see the data filtered according to the criteria block.

Example 3

To see rows of data for more that 2 particular items in the column ACCOUNT-CREDIT.

Say we want to view the data of 4 particular items from the column ACCOUNT-CREDIT.

In this case, we want to select more than two unique items from a single column. So we will use an Advanced Filter operation.

1. Set up a criteria block to look like this:

	A				B
33
34	ACCOUNT-CREDIT
35	BANK A
36	BANK B
37	BANK C
38	BANK D
39

The above setting indicates that we want to view rows where the column ACCOUNT CREDIT contain the item BANK A, BANK B, BANK C or BANK D.

2. Follow steps 3 to 8 as in Example 1 above.

You should see the data filtered according to the criteria block.

Example 4

To see rows of data of where an account name appear in both column ACCOUNT CREDIT and column ACCOUNT CREDIT in the same row.

Say we want to select rows where an account name BANK A appears in both the column ACCOUNT-DEBIT and ACCOUNT-CREDIT in the same row. In this case, we want to select items from 2 columns. So we will use the Advanced Filter operation.

1. Set up a criteria block to look like this:

	A				B				C
41
42	ACCOUNT-DEBIT	ACCOUNT-CREDIT
43	BANK A			BANK A
44

Notice that this criteria block starts at row 42 because the rows above it are used for other criteria blocks.

The above setting indicates that we want to view rows where the same account name appear in the same row under the column ACCOUNT-DEBIT and he item ACCOUNT CREDIT.

2. Follow steps 3 to 9 as in Example 1 above.

You should see the data filtered according to the criteria block.

184