Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is the benefit of using FLASH FILL in Excel? and what is accuracy of this function?

user-image
Question added by Majid Abdulrahman Mohammed Al-Thorah , Senior Auditor , Grant Thornton
Date Posted: 2016/02/25
krushnasinh chavda
by krushnasinh chavda , General Accountant , Pixel Digital Systems LLC - UAE

 

Flash fill is time saving feature which fill in data when pattern is recognized. It can also remove, insert and format. This feature can even reverse text, numbers and dates.

 

Oliver Watling
by Oliver Watling , Procurement Category Manager - Facilities , E2V Technologies Plc

Flash fill essentially makes data input faster and more accurate as it helps avoid typing errors by automatically detecting previous input.

Abu Bakar Ashfaq
by Abu Bakar Ashfaq , Senior Consultant , PricewaterhouseCoopers Middle East

In a new column next to existing data, enter a value that represents what you want to extract, combine, etc. Then, in the cell below, use this shortcut. Excel will try to apply the same pattern to all rows in the data. You can use Flash Fill with text, numbers, and dates.

Deleted user
by Deleted user

 

 

The property, which placed in Excel is a transfer or a rating or the inclusion of data from the boxes which codified them into other boxes as a package where you are when you're trying to do this process to take you time and effort, especially when some of the work, such as an account statement to customers or others shall be this way such as the process of Copy and Paste. Hence comes the importance and accuracy of this property but it is not the sophistication prospect errors such as the mobilization of all the data in one box instead of unloading all the information in a separate box.

           

 

 

More Questions Like This