Here's how I would set it up.

First, set an area of cells to represent your sign, using 1 cell per letter.
I know its not convenient for typing, but the formulas will work easier, and
it will help with alignment planning of your sign. Lets assume A1:G3. This
area will be for whatever the old message was.

Assign area A4:G7 to the new sign message.

Now, a list of all the letters/character you have available. I'll assume
they're in I1:I50

Ok, in J1, type
=COUNTIF($A$1:$G$3,I1)
In K1
=COUNTIF($A$4:$G$7,I1)
In L1
=K1-J1

Copy these cells down to row 50. Now, column L will tell you what changes
you need. A positive number means you need to bring more of that symbol.
Negative number means you already have enough, and some to spare.

Hope this at least gives you some ideas as to how to build your workbook.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bajohn56345" wrote:

I am looking for a way to use excel in changing the wording on the sign in
front of our church building. Every week we put up a new message. I pull the
letters for the person that changes the sign. I have to account for the
letters that are on the sign, pull the new letters needed while leaving the
ones that we will use again on the sign. There must be a way that I can
quickly use excel to tell me what new letters that I need.