I want to know if there is a way to add multiple numbers with letters to one cell and each number/ letter get eliminated when that number gets placed in another cell.
- cell b4 has: 4, 7, 8, 5H
- I put "5H" into any cell of E4:H4
- resulting in 5H being removed from cell b4 leaving just 4, 7, 8
I would like to be able to do this with any one, any multiple, or all the numbers in cell 5H to be removed when their numbers are entered into any of the cells of e4:h4.
Here is a copy of the Spreadsheet https://docs.google.com/spreadsheets/d/11uvHy49n0i-Yj905wm4B2d_M9THHp16hS5jTrgYvPu8/edit?usp=sharing