I am having troublt adapting this formula to feed in data from horizontal cells.
I am using this function here: =OFFSET(A2,0,0, counta(1:1)-1)
http://www.teachexcel.com/excel-tuto...-in-excel.html
I am having troublt adapting this formula to feed in data from horizontal cells.
I am using this function here: =OFFSET(A2,0,0, counta(1:1)-1)
http://www.teachexcel.com/excel-tuto...-in-excel.html
Hi Jocelyn
I suggest you post a sample workbook so we can see what you're working with.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I have attached a excel document. Call D23 is where I would like drop down menu and I would like it to pull data from D4, D5, D6 etc.
Does this make sense?
First in D4 dragged right, change the formula to
=IF(INDIRECT("Input!A"&0+(3*COLUMN(A3))-1)=0,"",INDIRECT("Input!A"&0+(3*COLUMN(A3))-1)+0)
this stores the number as a number, it was text.
Then for data validation in D23
=OFFSET($D$4,0,0,1, COUNT($D$4:$AG$4))
See attachment
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
You are the best, thanks for fixing our other formula! Thank you so much
Just a small change I would suggest to the data validation formula in cell D23:
=OFFSET($D$4,0,0,1,COUNT(4:4))
Makes it more dynamic, rather than limiting the option till column AG only.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks