Forum Discussion
Assign numeric value to text cell
If I understand what you're asking, it's VLOOKUP that you need. I've started it for you in the first three items on your list, with the assumption that you can follow the example and finish the rest. Feel free to come back with questions if you still have them.
Hello I think you may be able to help me
I have a staff rota and we use E (early shift) and L (late shift) i want the colobm at the side to add the hours together. So I want to hide the numerical value of those letters up. So for example L=10hours Lx5=50hours? mathetes
I may be able to help, and there are others here on this site who also may be able to help. But in order for anybody to help, you'll need to give a more complete picture (or post a copy of your actual workbook) of what it is that you're working with. And might I suggest that you start a new thread. It isn't really clear that this builds on what preceded it in this thread.