You could amend your COUNTIF like this
=OFFSET(Control!$Q$6,0,0,COUNTIF(Control!$Q$6:$Q$15,"?*"),1)
You could amend your COUNTIF like this
=OFFSET(Control!$Q$6,0,0,COUNTIF(Control!$Q$6:$Q$15,"?*"),1)
Don
Please remember to mark your thread 'Solved' when appropriate.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks