Drop List for a column...

[dleckie]

Hi All,

I have a two part question?

Is there a way to set up a colum so when you click on a cell there are 5 options to choose from? I would like those options to be :

Accepted
In Process
Modified
Placeholder
Rejected
To Do

Part two question - can this colum be totaled at the bottom stating there are X amount of each.

Thanks

Dave

[lucas]

See Attachment:
click on any of the yellow cells in Column A

It is made using data validation. Uses a range that is on sheet 2.


The totaling will require more info from you.

[dleckie]

Hey that is very nice. Now how do I do it?

As for the totaling... If Cells G1,2,5,7,9 are In Process, G3, 8,10,12 are Accepted, G14, 15 Rejected. I would like to see a total at the bottom.
In Process = 5
Accepted = 4
Rejected = 2

Note that there would be spaces inbetween.

[lucas]

To set up your data validation:

Go to sheet 2 or some other sheet and add your list as I have shown in my example. While on that sheet, select the range you entered and go to insert-name and give the range a name. I used myrange.

Now go to sheet1 or wherever you want your validation and select the first cell in column G.

Go to data-validation. Under the settings tab choose list from the "allow" drop down.

the type =myrange in the source box that appears and click on ok.

That sets up the drop downs.

The counts in the current attachment were done with a countif formula. You can click on each one and see what it does by looking in the formula bar.