Forum Discussion
Flash Fill Not Recognizing Pattern for Tens of Thousands of Rows
Flash Fill isn't reliable. Actually you shall to check all records if they are converted correctly. I know many people like it and in many cases it does the job, but I personally prefer to avoid Flash Fill.
To populate the formula it's not necessary to drag cell down. Let assume your formula is in D2 and you'd like to fill with it entire range till D989789. Stay on D2, same address will be visible in name box (top left from sheet area, left from formula bar). Type here D2:D989789, Enter (range will be selected) and Ctrl+D.
Flash Fill isn't reliable. Actually you shall to check all records if they are converted correctly. I know many people like it and in many cases it does the job, but I personally prefer to avoid Flash Fill.
To populate the formula it's not necessary to drag cell down. Let assume your formula is in D2 and you'd like to fill with it entire range till D989789. Stay on D2, same address will be visible in name box (top left from sheet area, left from formula bar). Type here D2:D989789, Enter (range will be selected) and Ctrl+D.
SergeiBaklan Best solution! Thank you!
AlexRadcliff , glad to help