Dependent dropdown query - hiding items selected in prior column
 

Background: I'm creating a reporting sheet in excel for an exercise research
trial. The report will show the type of exercise used in each session, and
any progressions. Multiple progressions are relevant to each exercise, and
the programme deliverer may need to record one or more progressions for each
exercise used. (I've set this out in columns of exercise, progression 1,
progression 2...). To reduce human error while reporting when multiple
progressions have been used in a single session, I would like to be able to
hide items already selected in the previous column.

I've got as far as creating dropdown lists based on the selection made in
the prior column (using INDIFFERENT in the data validation source box) which
is working well. I've had a long browse through this forum (including using
combo boxes instead of data validation, and
http://www.contextures.com/xlDataVal03.html), but I'm struggling to adapt it
successfully to hide previously selected items.

All thoughts welcome, and my apologies if this has been asked and answered
elsewhere and I've overlooked it,

many thanks for your assistance

Juliet

Dependent dropdown query - hiding items selected in prior column
 

Erratum: sorry, should be "INDIRECT" (not indifferent)
Thanks
Juliet

"Juliet" wrote:

Background: I'm creating a reporting sheet in excel for an exercise research
trial. The report will show the type of exercise used in each session, and
any progressions. Multiple progressions are relevant to each exercise, and
the programme deliverer may need to record one or more progressions for each
exercise used. (I've set this out in columns of exercise, progression 1,
progression 2...). To reduce human error while reporting when multiple
progressions have been used in a single session, I would like to be able to
hide items already selected in the previous column.

I've got as far as creating dropdown lists based on the selection made in
the prior column (using INDIFFERENT in the data validation source box) which
is working well. I've had a long browse through this forum (including using
combo boxes instead of data validation, and
http://www.contextures.com/xlDataVal03.html), but I'm struggling to adapt it
successfully to hide previously selected items.

All thoughts welcome, and my apologies if this has been asked and answered
elsewhere and I've overlooked it,

many thanks for your assistance

Juliet

Dependent dropdown query - hiding items selected in prior column
 

Maybe the sample file here will help a bit mo

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0047 - Hide Previously Used Items in
Dependent Lists'

Juliet wrote:
Background: I'm creating a reporting sheet in excel for an exercise research
trial. The report will show the type of exercise used in each session, and
any progressions. Multiple progressions are relevant to each exercise, and
the programme deliverer may need to record one or more progressions for each
exercise used. (I've set this out in columns of exercise, progression 1,
progression 2...). To reduce human error while reporting when multiple
progressions have been used in a single session, I would like to be able to
hide items already selected in the previous column.

I've got as far as creating dropdown lists based on the selection made in
the prior column (using INDIFFERENT in the data validation source box) which
is working well. I've had a long browse through this forum (including using
combo boxes instead of data validation, and
http://www.contextures.com/xlDataVal03.html), but I'm struggling to adapt it
successfully to hide previously selected items.

All thoughts welcome, and my apologies if this has been asked and answered
elsewhere and I've overlooked it,

many thanks for your assistance

Juliet







--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Dependent dropdown query - hiding items selected in prior colu
 

Thanks Debra for the prompt response. I did see this example previously but
I'll work on orienting the formula to hid selection made in previous column
rather than row, and post again if still having problems.

Thanks again

Juliet



"Debra Dalgleish" wrote:

Maybe the sample file here will help a bit mo

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0047 - Hide Previously Used Items in
Dependent Lists'

Juliet wrote:
Background: I'm creating a reporting sheet in excel for an exercise research
trial. The report will show the type of exercise used in each session, and
any progressions. Multiple progressions are relevant to each exercise, and
the programme deliverer may need to record one or more progressions for each
exercise used. (I've set this out in columns of exercise, progression 1,
progression 2...). To reduce human error while reporting when multiple
progressions have been used in a single session, I would like to be able to
hide items already selected in the previous column.

I've got as far as creating dropdown lists based on the selection made in
the prior column (using INDIFFERENT in the data validation source box) which
is working well. I've had a long browse through this forum (including using
combo boxes instead of data validation, and
http://www.contextures.com/xlDataVal03.html), but I'm struggling to adapt it
successfully to hide previously selected items.

All thoughts welcome, and my apologies if this has been asked and answered
elsewhere and I've overlooked it,

many thanks for your assistance

Juliet







--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Dependent dropdown query - hiding items selected in prior colu
 

There's another example that doesn't have dependent lists, but hides
selections made in previous columns:

http://www.contextures.com/excelfiles.html
DV0016 - Assign Employees to Single Task Per Day

If you're still stuck, you could give a bit more detail on the sheet
layout, with an example of how the dependent lists should work. Then
someone might be able to give you some specific help.

Juliet wrote:
Thanks Debra for the prompt response. I did see this example previously but
I'll work on orienting the formula to hid selection made in previous column
rather than row, and post again if still having problems.

Thanks again

Juliet



"Debra Dalgleish" wrote:


Maybe the sample file here will help a bit mo

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0047 - Hide Previously Used Items in
Dependent Lists'

Juliet wrote:

Background: I'm creating a reporting sheet in excel for an exercise research
trial. The report will show the type of exercise used in each session, and
any progressions. Multiple progressions are relevant to each exercise, and
the programme deliverer may need to record one or more progressions for each
exercise used. (I've set this out in columns of exercise, progression 1,
progression 2...). To reduce human error while reporting when multiple
progressions have been used in a single session, I would like to be able to
hide items already selected in the previous column.

I've got as far as creating dropdown lists based on the selection made in
the prior column (using INDIFFERENT in the data validation source box) which
is working well. I've had a long browse through this forum (including using
combo boxes instead of data validation, and
http://www.contextures.com/xlDataVal03.html), but I'm struggling to adapt it
successfully to hide previously selected items.

All thoughts welcome, and my apologies if this has been asked and answered
elsewhere and I've overlooked it,

many thanks for your assistance

Juliet







--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Dependent dropdown query - hiding items selected in prior colu
 

Thanks Debra, that's perfect!

Regards

Juliet

"Debra Dalgleish" wrote:

There's another example that doesn't have dependent lists, but hides
selections made in previous columns:

http://www.contextures.com/excelfiles.html
DV0016 - Assign Employees to Single Task Per Day

If you're still stuck, you could give a bit more detail on the sheet
layout, with an example of how the dependent lists should work. Then
someone might be able to give you some specific help.

Juliet wrote:
Thanks Debra for the prompt response. I did see this example previously but
I'll work on orienting the formula to hid selection made in previous column
rather than row, and post again if still having problems.

Thanks again

Juliet



"Debra Dalgleish" wrote:


Maybe the sample file here will help a bit mo

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0047 - Hide Previously Used Items in
Dependent Lists'

Juliet wrote:

Background: I'm creating a reporting sheet in excel for an exercise research
trial. The report will show the type of exercise used in each session, and
any progressions. Multiple progressions are relevant to each exercise, and
the programme deliverer may need to record one or more progressions for each
exercise used. (I've set this out in columns of exercise, progression 1,
progression 2...). To reduce human error while reporting when multiple
progressions have been used in a single session, I would like to be able to
hide items already selected in the previous column.

I've got as far as creating dropdown lists based on the selection made in
the prior column (using INDIFFERENT in the data validation source box) which
is working well. I've had a long browse through this forum (including using
combo boxes instead of data validation, and
http://www.contextures.com/xlDataVal03.html), but I'm struggling to adapt it
successfully to hide previously selected items.

All thoughts welcome, and my apologies if this has been asked and answered
elsewhere and I've overlooked it,

many thanks for your assistance

Juliet







--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html