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. Just wondering when the Pagoda will be added to the planner Dr. 1 Im probably in the wrong thread, please advise. (never mind the Special Units in orange in column G for now) Thread starter Cleavus Start date Cleavus New Member. 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'. B31 to F31 shows the current Units attached to the B1 AGE or ERA. Any selection in that area has True False labels in the G33 to K50 area. This changes all of the drop down boxes in G4 to K11. 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. 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. I have had great experiences on this and other excel forums with all of the help I have received doing my little projects.

Forge of empires city planner excel