Hopefully this is easy. I'm wanting a created name to show in the dropdown list on a certain spreadsheet. The purpose of this name is to position myself to the last entry in the sheet in Column A.
I went to name manager and created a name like this:
=OFFSET('Office 365 Spam Processing'!$A$2121,0,0,COUNTA('Office 365 Spam Processing'!$A:$A)-1) and called it Blocked
I started with A2121 because there were some cells above that that were blank.
In any case, it takes the name but won't show it to me on the dropdown list of names when on that sheet. How do I get it to appear?
Bookmarks