Microsoft Excel allows data to be combined many ways. Some techniques discussed in this chapter are IF statements, the TEXT function, PivotTables and Filtering, Grouping, VLOOKUP, HLOOKUP and MATCH.
Librarians need to combine data frequently, in many ways. This chapter shows methods of combining data using If statements, the TEXT function, PivotTables, filtering PivotTables, Grouping, VLOOKUP, HLOOKUP and MATCH with Microsoft Excel.
IF(logical_test, value_if_true, [value_if_false])
Or, in other words:
IF (something is true, do this, otherwise do something else)
In this example, we would like to summarize the data by showing how many ...