CODEWITHSUNDEEP
excel-formula
MEC
MEC

Reputation: 233

Dynamic Validation but with Columns

I am trying to do a dynamic data validation list using row 5 and adding columns as data is added to those columns. So I have googled and found lot's of offset formulas that are designed to offset on rows but my data is in columns (D5, E5, F5, G5, H5, etc ....). I tried adapting this formula but it doesn't give me what I want:

=OFFSET('Borrower Database'!$D$5,0,0,COUNTA('Borrower Database'!$5:$5),1)

I want my list to read from the columns on row 5 and dynamically grow as I add more names to the next columns.

Can anyone tweak this formula for me?

Upvotes: 0

Views: 32

Answers (1)

toroc
toroc

Reputation: 126

You are almost there :) Look at OFFSET function definition. In your formula [height] is swapped with [width]. Corrected formula:

=OFFSET('Borrower Database'!$D$5,0,0,1,COUNTA('Borrower Database'!$5:$5))

Upvotes: 1

Related Questions