In cells A4 to E11 is just formulas that I had tested most recently. 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. We believe that this feature will be useful for those of you who are sure about winning battles before they even begin. I have an Excel workbook that I would like to have some help with as I have tried several ISTEXT, VLOOKUP etc. On 5th of December, we will present you with a brand new option that allows you to perform an automatic battle directly from the pre-battle army management screen.

I have had great experiences on this forum with all of the help I have received doing my little projects.

Auto battle forge of empires