Fortune teller Excel_ Fortune teller source code

What should I do if the data originally belonging to the same row is misplaced after EXCEL sorting, the kind with a lot of data?

Since the amount of data is large, there are naturally special cases, and you have not said the formula format, it is difficult to find a fortune teller by any guess.

1. If the formula has no cross-line reference, there is a choice when sorting, and the whole line can move with the sorted data.

2. If there is a cross-line reference in the formula, adjust the formula of the characteristic line, and then copy and paste the data (the original data is sorted, and the formula data is recalculated directly without dislocation error);

Generally, formulas containing cross-line data are included. The first line is special because there is no pre-data, and subsequent lines can have characteristic formulas.

3. If the data will not change, you can copy (value) from the original table and sort it, so there will be no calculation (even if the formula has cross-line reference, it will not change because it has been fixed as the calculation result value), so there will be no more errors.