# Tag Info

1

Here's a Query that can do the trick : =QUERY(Data!B1:D,"SELECT B,AVG(C),AVG(D) GROUP BY B ") You can use label to rename the column's header.

0

New solution : =or(ArrayFormula( regexmatch(iferror( FILTER(Sheet1!\$B\$2:\$B\$9;int(Sheet1!\$A\$2:\$A\$9)=B\$2) );\$A3) )) It filter the original list to pick up which names appears on a determined dates. Then it checks if the name exist in the list. Using your formula, here's a way to do it : =IF( AND( or(ArrayFormula(B\$2=int(Sheet1!\$A3:\$A10))), ...

0

Problem 1 : Page-2-Seznam članov > Coloumn C : It needs to be the max dates. The function need to search on the list the name from Page-2-Seznam članov > Coloumn B and in area Page-3-Podaljsave to give the outpoot from the same person the exact max date from Page-3-Podaljsave > Coloumn E In Page 2 > column C > cell C3 you can use ...

0

Use REGEXMATCH : =countif(ArrayFormula(regexmatch(A1:A10,"^Bud Light\$")),true) This formula counts the cells who match the regex ^Bud Light\$ : Match exactly Bud Light You can add lower() and proper()to clean the range you want to test.

Top 50 recent answers are included