Find 01)

01) Compare Data Sets. Select Criteria Columns. Last Selected Differentiates b/n Data Sets. Select Value Columns

This function is all about comparing two or more data sets. If comparing data is a pain, watch these videos to find out how to feel good again.


This first video is a more traditional comparison, it sums on the decimal of interest and we also provide a column that differentiates one data set from another.
Download FIND 01 Example 1 and follow along.


This second video shows how to compare two name and address data sets. Since there is no logical column to sum on, we’ll create a column and populate it with the number 1. Finally, we’ll see how we can pick a blank column to use as the differentiating column.
Download FIND 01 Example 2 and follow along.


This third video shows how to compare data sets contained on the same page. In the two previous examples each tab contained a distinct data set.  We used a column that either contained the same value in each row, or a column that was blank, to differentiate between each data set.

In this third example we see how different data sets can be stacked on top of each other as long as one of the columns contains a different value for each of the data sets. In this case we’ll use the DECK field to differentiate between each of the 9 data sets we’re comparing.
Download FIND 01 Example 3 and follow along.



Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc