r/excel•
junibo

Why does flash fill not recognize my pattern with the round function?

solved

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
rnelsonee648•

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.

asting the formula appears to correctly paste the formula, but it evaluates to the value of the copied cell.

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.

2
juniboOP•
1
rnelsonee648•

Hmm, go to formulas tab and make sure calculations are set to auto and not manual....

2
juniboOP•

That seems to have done it. Thanks!

1