I am getting a #Name error

Iron Contributor

I am getting a #Name error. I need help. I have try trim removing any extra spaces. I am not sure what to do.

 

 

Thanks You

6 Replies

@sf49ers19238597 

Error checking reports no problems, and I don't see #NAME! anywhere.

Where do you see it?

Please note that the formulas in the workbook require Microsoft 365 or Excel Online. They won't work in older versions.

 

[... deleted; distraction ...]

 

@Joe User 

Hey Joe, it is true that Excel Online does not support all features of the desktop version, but it does support all new functions - the formulas in the workbook work correctly in Excel Online.

[... deleted; distraction ...]

I see name# in cell D15:D32. the formula is in cell D15

I also see BYE in Column C that should not be showing in there.

@sf49ers19238597 

The formulas in D15:D32 on the 49ERS sheet will only work in Excel in Microsoft 365. Which version do you have?