Good Afternoon, can somebody please help:
I am trying to set up a dynamic range for a combobox, here is the code that I have entered in the 'Name Manager'
Code: =OFFSET('Off Road'!$CD$3,0,0,(COUNTA('Off Road'!$CD$3:$CD$5000)-COUNTIF('Off Road'!$CD$3:$CD$5000,"=0"))-1)
I am trying to filter all of the cells that contain a zero however when viewing in a comobox I get all 5000 lines
Any help would be much appreciated
Thanks
Brian
I am trying to set up a dynamic range for a combobox, here is the code that I have entered in the 'Name Manager'
Code: =OFFSET('Off Road'!$CD$3,0,0,(COUNTA('Off Road'!$CD$3:$CD$5000)-COUNTIF('Off Road'!$CD$3:$CD$5000,"=0"))-1)
I am trying to filter all of the cells that contain a zero however when viewing in a comobox I get all 5000 lines
Any help would be much appreciated
Thanks
Brian