Posts by João Paulo • 1 point

• 0

  votes

  1

  answer

  269

  views

  A: Query Excel with cell criteria

  You can try to create two variables and use the variables instead of the date itself See image below…

  mysql sql excel powerquery

  answered 4 years, 5 months ago João Paulo 1

• 0

  votes

  1

  answer

  36

  views

  A: Get values for a new line on a graph

  Hello You can create a Range with Shift. Suppose you have the situation below You can create a field through the name manager Using the formula =DESLOC(Planilha1! $A$2;0;0;CONT.NÚM(Planilha1!…

  excel

  answered 4 years, 5 months ago João Paulo 1