Why does flash fill not recognize my pattern with the round function?
I have values in column A. In B1 I have '=round(A1,1).' In B2, I have '=round(A2,1)' etc... It would be nice to flashfill the rounding operation, but it won't recognize the pattern. Any help would be appreciated.
edit: It seems to be buggier than I thought. Pasting the formula appears to correctly paste the formula, but it evaluates to the value of the copied cell.
Posted Aug 25, 2016, 12:06 AM UTC · edited
14
Flash fill is designed for finding patterns in values (that's how I see it). If you want to copy the formula down, just double-click the fill handle or drag it down.
I'm not sure what that means, but after pasting the formula (or using the fill handle or selecting cells first and hitting Ctrl+Enter to enter the formula), it should look like this.
This is what I get when I use the fill handle.
Hmm, go to formulas tab and make sure calculations are set to auto and not manual....
That seems to have done it. Thanks!