Data Clean-Up and Management

7

Excel: combining data

Abstract:

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.

Key words

combine data

if

pivot

filter

group

lookup

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 statements

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 ...