Hi I really need some help with this formula to produce a dynamic named range
=offset(A1,,,countif(a1:a10,"?"),7)
THE "?*" excludes cells with "" null
every time I put it in a named range it works however when I refer to the named ranged in a pivot table it says an not find source
Bookmarks