> Mapping is done by writing the formula once and then dragging it from the corner to the whole column. Filtering is not really done. Normally use the gui to hide the rows to be filtered away.

You should look into array formulas (or block formulas). They break out of the one-at-a-time mold and could be much more powerful.