Here's another simple formula, using the OFFSET function, entered in cell C19: If a spill cell is selected, the formula can be seen in the Formula bar, in grey font, but it cannot be edited.The formula can only be edited in cell C19, where it was entered.If you select any cell in the formula results, a thin blue border appears around the spill range.The formula results spill into the adjacent rows and columns, as far as needed, to show all 9 cells that the formula refers to
In this example, there is a formula in cell C19, which refers to some of the sample data: IDīefore we look at Excel's new spill functions, let's see what happens with a "normal" worksheet formula. In the sample file, the ID heading is in cell C4, and the last note is in cell F11. This is the test data that is used in some of the spill formulas. You can get the sample file, with all of these examples, and several additional examples, in the download section. The examples below show how to use Excel's new functions, such as FILTER and SORT, and you'll see how older functions, and custom VBA functions, can "spill" too.
Normal formulas can only fill the cell they are in, but "spill formulas" can fill neighbouring cells. More Function Tutorials Intro: Spill formulas
0 kommentar(er)
