O'Reilly logo

Data Clean-Up and Management by Kenneth Furuta, Margaret Hogarth

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required