Dynamic drop down list

**stevewilde** · 12-07-2009, 10:03 AM

I am trying to do a dynamic drop down. The left one is working fine, where as the right one is not. (see example) I just cannot get a complete list, even though I am using the same formula - any ideas??

Thanks

**md1972** · 12-07-2009, 10:09 AM

Where's your list validating from? From sheet 3? I didn't think you could validate from a seperate sheet.

**DonkeyOte** · 12-07-2009, 10:09 AM

You're using COUNT to establish height of dynamic range - this works for A given the values to list are numbers - this is not so in Column C which contains a mixture of data types - use COUNTA rather than COUNT and subtract from that number the count of any non-blanks in the range that are NOT to be listed (header/footer etc...)

(note as things stand your ranges don't encompass all values...)

**stevewilde** · 12-07-2009, 10:16 AM

Originally Posted by DonkeyOte

You're using COUNT to establish height of dynamic range - this works for A given the values to list are numbers - this is not so in Column C which contains a mixture of data types - use COUNTA rather than COUNT and subtract from that number the count of any non-blanks in the range that are NOT to be listed (header/footer etc...)

(note as things stand your ranges don't encompass all values...)

Thank you - that has done the trick