How to use the FILTER() function in Excel. Using FILTER() has one requirement: You must use the same headers in the filtered set range. The original data set in B2:F14 is the source data.

Familiarity. Microsoft Excel launched in 1982 (under the name Multiplan) as a basic, though reliable, spreadsheet software program -- that's steadily evolved to meet its consumers' needs.

Implicitly, the Excel API acknowledges that most businesses use (and abuse) Excel to store lots of data. Using the service, developers will be able to perform calculations based on this data ...