Dynamic Range in a List Box with a blank choice?

  • Thread starter Thread starter hutch
  • Start date Start date
H

hutch

Ok... so far so good !! 8-) ... I'm happy!
I have a named dynamic range similar to this.
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)

.... and (by golly) it shows up in my list when I do Data>Validation>allow
list on another sheet!

But how do I provide a blank?
What I want to do is if a referenced cell is blank (no input from the user)
then the list shows a blank?

A little bit about what I'm headed for:

I am trying to develop a time sheet that will track:
time spent
running total time
what task I spent the time on (this is where my list box comes in)
then on another sheet I want to show each task and the time spent on each as
well as the percent of the total time spent on each task.

Make sense?

But one step at a time..!
If there is no entry on a given row then the task list cell needs to be
blank (or invisible perhaps)
????
 
If you really want a blank to show up in your dropdown, how about making A1
blank (shift everything down a row). Then adjust your formula:

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A)+1,1)

If you had 9 cells with values, then counta()+1 will give 10.
 
Back
Top