reducing the list

Harlan2010

New Member
Joined
Sep 9, 2010
Messages
14
I'm using Excel as a log for transactions one of which is purchase orders. I have a block of numbers available for purchase orders - 100 -250.

What I would like to do is format a column called PO Numbers and let people pull the num,ber form the list for making an entry on that row. However I would like in subsequent rows on that column to no show numbers which had been previously used.

So my list would be:

100
101
102
103
104
105
106
107
108
109
110

A person could pick say 104 and complete an entry for PO # 104 on that row

100
101
102
103
104
105
106
107
108
109
110

When another person goes to make a new entry in the log they would have these numbers to pick from

100
101
102
103
105
106
107
108
109
110

104 would no longer be available

Is there a function or other operation that I can employ?
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,130,029
Messages
5,639,623
Members
417,101
Latest member
amoverton2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top