Forum Discussion
Excel Formula/function help; 2 step confirmation for a 3rd Value
Hello, I have multiple sports team members taking a self assessed skills survey. They will take this survey multiple times. To graph the results I am trying to find the formula/function that will all...
Thanks, I added in a sample.
so in screen #2 under the S you could use something like:
=FILTER(DataTable[[Speed]:[Knowledge]],(DataTable[ID #]=1)*(DataTable[Self Survey Number?]=1),0)
if there is a chance of multiple rows matching then maybe add an @ in front or INDEX(... ,1,) or get fancy and put it all in a lambda and do a ByCol and Average each set.
BTW the above is using structured reference (or table references) and would work if you formatted the original data table "Format as a Table" from the HOME tab and then named that table (Table tab) "DataTable"
That said, I also don't know where the numbers 1 and 1 come from for that line. If you had the expected #s somehow linked to that second table then you could make it even more dynamic and not have to customize every row/section
=FILTER(DataTable[[Speed]:[Knowledge]],(DataTable[ID #]=1)*(DataTable[Self Survey Number?]=1),0)
if there is a chance of multiple rows matching then maybe add an @ in front or INDEX(... ,1,) or get fancy and put it all in a lambda and do a ByCol and Average each set.
BTW the above is using structured reference (or table references) and would work if you formatted the original data table "Format as a Table" from the HOME tab and then named that table (Table tab) "DataTable"
That said, I also don't know where the numbers 1 and 1 come from for that line. If you had the expected #s somehow linked to that second table then you could make it even more dynamic and not have to customize every row/section