Unique drop down list

S

Saintsman

I have a number of projects, divided into 4 stages - start; midway;
completion; defects.
How can I create a unique list of job numbers from a growing list of projects
I use named ranges generally, but this give me a list of all records & the
project number appears several times in different positons on the list
I want my users to select a project number from a drop down list (data
validation) to lookup details against - ideally in order

Data entry view
Project Stage
1 Start
2 Start
3 Start
1 Midway
2 Midway
3 Midway
1 Completion

Any ideas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down lists in seperate columns 5
Build Team in a Project Detail Page? 0
Paragraph numbering in Word 1
Limit drop down items based on another cell 3
Link a text box based on drop down box with four options MS Word 365 0
Data Validation - Conditional List 3
Using (SUM(IF(FREQUENCY....to determine unique values 2
Formatted cell column in drop down list 1

Top