Remove an item from a validation list after selected?

**hey_ray** · 02-10-2012, 10:18 PM

Hello,

I am a softball coach and I want to create a fielding roster for my team. I have all the players names in column A (A4:A14). I have positions listed in column L (L4:L15) as follows: P, C, 1B, 2B, SS, 3B, LF, LC, CF, RC, RF, X. Cell range B4:H14 (7 innings) is where I need to have drop downs, but once I select a certain positions for one player in inning 1, for ex., I want it to not be available for the next player in the same inning. Can someone please help as I have been driving myself crazy trying to figure out how to do it myself.

Ray

**hey_ray** · 02-10-2012, 11:15 PM

All of the info/data above is on the same spreadsheet (sheet/tab 1).

Please see attached.

**WHER** · 02-11-2012, 06:57 AM

One way to do this, see attachment.

**hey_ray** · 02-13-2012, 09:01 PM

Thanks WHER!!! That'll work!

**Pradeep.p** · 05-09-2013, 07:48 AM

Hi,
This attached file having formulas in alpha but i want to update numerics in that same data validation.
Can you please suggest me how to update the numerics in that same data.

**hey_ray** · 02-23-2014, 02:08 PM

Hello again.

This report above has served me well over the last 2 years. I need to add players to it and "X" values to the the "Full List". After a couple hours of trying to do it myself I have become too frustrated

I just want the report to be based on a team with 12 players and have another X added to the full list (X indicates players who are sitting).

If you can provide a spreadsheet with the changes that would great! In addition, if you could please let me know how to add more players and values to the full list, I can take care of this in the future.

Much appreciated.

Ray

**newdoverman** · 02-23-2014, 05:18 PM

Here is a workbook modified to more or less look like yours and it includes drop-down lists for each inning based on a listing to the right of the Player lists.....don't enter anything in this list off to the right.

This appears to be based on the same basic workbook as yours.