4 ms·
Excel actually checks that and gives you an 'Inconsistent formula' warning with a little green corner similar to when you comment a cell. All you need to do is
by reportgunner 6y ago
Excel actually checks that and gives you an 'Inconsistent formula' warning with a little green corner similar to when you comment a cell.
All you need to do is scroll through the worksheet you have just made.
- iso1631 6y agoAll you need to do is scroll through 20,000 lines looking at each one
- reportgunner 6y ago20,000 is not a lot of lines though, I used to scroll 300k sometimes. Anything below 500k rows is a 'small table' still.
- iso1631 6y agoThe point is that's a manual, tedious, process that will be performed with error or completely skipped. We have computers to do that sort of work.
- reportgunner 6y agoIt is a manual and tedious process if you make it manual and tedious for yourself. After all, it's people that make computers do this work in the first place.
- Isthatablackgsd 6y agoExcel have an ability to highlight the cell that have invalid data with a red circle to make it pop out on the table. Just look for something red.