I have a dynamic named range (_nameslist) with this Formula: 1'!$AE$7:INDEX('1'!$AE$7:$AE$22,COUNTA('1'!$AE$7:$AE$22)). This working well asit (Expands/Shrink) when names added or deleted.
But, when I use this formula: IFERROR(_namesList,"") in the range C7 to C22 it works well if I have more than 1 names in the dynamic named range/list, if there is only 1 name then it fills the whole range C7 toC22 with the same name that I have in my dynamic list. If I enter a blank space in the next cell (AE8) in the dynamic list then also it works.
Could anyone tell why is this happening and what is thesolution for this problem?
Thanks
But, when I use this formula: IFERROR(_namesList,"") in the range C7 to C22 it works well if I have more than 1 names in the dynamic named range/list, if there is only 1 name then it fills the whole range C7 toC22 with the same name that I have in my dynamic list. If I enter a blank space in the next cell (AE8) in the dynamic list then also it works.
Could anyone tell why is this happening and what is thesolution for this problem?
Thanks