Hello
I need to create a dynamic range.
I am using the following:
=OFFSET('[Targets.xlsx]Target Report'!$A$1,0,0,COUNTA('[Targets.xlsx]Target Report'!$A:$A),1)
However the column ‘A’ that I am referencing has a mixture of cells containing text and also cells containing numbers which I think is causing a problem.
Can anyone advise on how I need to amend things.
Kind regards
Try replacing the COUNTA part with this.
Formula:
Please Login or Register to view this content.
Last edited by skywriter; 03-17-2015 at 10:21 PM.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
Thank you for your very quick response. I could not get your fix to work, but that is probably because there is something else going on that I do not understand. I have chosen to just use a fixed range and made it quite large to cater for expansion of the range.
Kind regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks