Skip to main content
added 116 characters in body
Source Link

The easier way to solve the problem is to remove the blank rows below the data range (from row 12 to the last row of the sheet)


Removing IFERROR`IFERROR` the cell with the formula shows the following error

Replacing A1:AA1:A by A1:A11A1:A11

If we replace A1:A11 by A2:A12 we get the following

The easier way to solve the problem is to remove the blank rows below the data range (from row 12 to the last row of the sheet)


Removing IFERROR the cell with the formula shows the following error

Replacing A1:A by A1:A11

The easier way to solve the problem is to remove the blank rows below the data range (from row 12 to the last row of the sheet)


Removing `IFERROR` the cell with the formula shows the following error

Replacing A1:A by A1:A11

If we replace A1:A11 by A2:A12 we get the following

Source Link

The easier way to solve the problem is to remove the blank rows below the data range (from row 12 to the last row of the sheet)


Removing IFERROR the cell with the formula shows the following error

Replacing A1:A by A1:A11