2 sheets tagged with "column formulae":

Row and column level formulae allow you to apply a formula to every row or column in a worksheet. They are extremely useful for removing duplication and avoiding certain kinds of common errors in spreadsheets.

You can also use them in surprising ways; like combining them with list comprehensions to do data aggregation.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

Once you have Resolver One up and running it is likely that you'll want to try out some of your existing Excel spreadsheets. Resolver One supports many of the features of Excel, so importing spreadsheets often requires few or no changes; more importantly once the spreadsheet is running on Resolver One you can take advantage of its features to make spreadsheets easier to maintain and less prone to errors.

This is an example Excel workbook, along with its equivalent converted for Resolver One. It accompanies the tutorial on converting Excel spreadsheets from the Resolver One documentation.

The Excel original uses the VLOOKUP function, along with INDEX and MATCH, to do dynamic lookups.

The Resolver One version does the lookups with headers, making for simpler formulae, and uses column level formulae to make it simpler to add new data.