Common Error: Incorrect Input Range Format

Issue Explanation

The input range format is incorrect. This error occurs when the selected range does not follow the required format(A1 Notation).

Correct Format

The correct format for the input range should include the following:

• Sheet Name: The name of the sheet.
• Beginning Cell: The starting cell of the range.
• End Cell: The ending cell of the range.
• Example: Data!A1:B2 (in A1 notation format).

Solution

• Use the Update Button: Click the "click to update input range"  button to automatically update the range based on your selection in the sheet.

Ensure your input range is in the correct format before proceeding.