• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Name Ranges

D

DawidV

New Member
Hi All

I am using Excel 2016 and i am battling to get a named range to work. i have downloaded dozens of YouTube videos on the subject but i am still getting errors. i will attach my error so i someone can plse tel me what am i doing wrong.

I am actually trying to make an filter to search for information in an excel sheet.
 

Attachments

  • RBS COURSES PER MEMBER 02 JUNE 2016 - Copy.xlsx
    20.2 KB · Views: 3
  • Doc1.doc
    375 KB · Views: 3
Hi ,

The formula you have used works correctly in Excel 2007 and Excel 2010.

Can you enter the same formula in a worksheet cell and see if Excel generates an error ?

=OFFSET(Lists!$B$5,,,COUNTA(Lists!$B$5:$B$150))

If there is no error , then it is possible that the name RANK is the problem.

Narayan
 
Hi Narayan

I am still getting the same error. I uninstalled Office 2916 and installed 2010. the example i send you was made in Excel 2010.
I now reinstalled 2016 and i am still getting the error. If i put the (') in front of the = then the formula is not working anymore.
as you say it works in 2007/2010, plse make the two named ranges in the example i send you then send it back to me then i will see it it works if I copy the sheets back into my workbook. if that is not working then i do not know any more.

thanx

Dawid
:confused::confused::confused::)
 
Thanx for the help.

I am away for work . Will come back to you ASAP.

I really appreciate the assist.

Regards

Dawid
 
You must log in or register to reply here.
Back
Top