I will Thank and mark solved on both when finished.
In cells A4 to E11 is just formulas that I had tested most recently.Ĭrossposted on Mr Excel Forums below. My problem is that I cannot figure out a way to have the "X" show up correctly if more than one is chosen on a particular row 4 thru 11. A HEAVY Unit is most effective against a Light Unit or Fast Unit. What is ultimately accomplished is to allow the player to see the correct "Stronger Unit" to fight against the opposing players "Weaker Unit" in the battles automatically.Įxample: a LIGHT Unit is most effective against a Fast Unit or Artillery Unit.
(never mind the Special Units in orange in column G for now) The X may be much simpler and would work just fine. In cells A4 to E11 I want the corresponding weaker units that the opposing players units are fighting against (selected in G4 to K11) to show up either with their correct title (listed in B14 through F27) or just a simple "X". This changes all of the drop down boxes in G4 to K11.Īny selection in that area has True False labels in the G33 to K50 area.ī31 to F31 shows the current Units attached to the B1 AGE or ERA. What the person does first, is select the ERA or AGE they are in, in Cell B1. I have an Excel workbook that I would like to have some help with as I have tried several ISTEXT, VLOOKUP etc. Is there any problem with FoE City Planner When I try to log in with correct e-mail and password, the message 'Username or password is incorrect' pops up all the time. I have had great experiences on this and other excel forums with all of the help I have received doing my little projects.
0 kommentar(er)
