help - names

Hi all, I have an overview that looks like this: Days since beginning / ended? Start date End date 01-10-2019 01-11-2023 01-10-2017 01-11-2025 01-10-2018 01-11-2028 01-10-2016 01-11-2021 01-10-2015 01-11-2018 And in Excel: I want to create a formula in column A that...

Hi, I'm trying to create a league tournament for a 10 deck vs. 10 deck card game. For each victory I fix the score of the duel and click on a button to launch the macro which will implement the different tables. I name my tables with the name of the decks. My question: I have 2 dropdown menus...

Hello everybody, I currently have an excel sheet that looks similar to this (but much larger): And then a master data sheet next to it that looks like this: Please note that some of the titles are not in the master data set (in reality however, they all are, i just created this example...

Does anyone have any idea why this code only searches the first row with a matching header instead of every row with a matching header? =COUNTIF(INDEX($A$4:$F$360,MATCH(LEFT(L$4,3),LEFT($A$4:$A$360,3),0),0),$J16&", "&LEFT($K16,1))+N16 Array $A$4:$F$360 with header $A$4:$A$360,3 trying to...

I dont know if i just dont understand things, but as for my understandings this formular just doesnt work for me in this scenario. I want to refer to an already existing name with INDIRECT(). I want this range to end up as my dropdownlist. The name i want to refer to is called "DropDown1"...