Questions tagged as 'formulas'

Suppose I have the following table: |-----|-----|-----|-----|-----|-----| | A | B | C | D | E | F | |-----|-----|-----|-----|-----|-----| 1 | s | n | n | s | s | s | |-----|-----|-----|-----|-----|-----| 2...

I have a parameter of dates accommodated by levels, taking into account today's date, 30 dias antes de hoy = fase1, 45 dias antes de hoy =fase 2, 60 dias antes de hoy=fase 3, 90 dias antes de hoy = fase 4 y mas de 90 dias apartir de hoy=fa...

I have a table in Excel that represents the purchase orders. Ex: pedido | linea ped. | estado línea ----------------------------------- 1 | 1 | Cumplido 1 | 2 | En progreso 2 | 1 | Cumplido...

I want to change the 'values' cells I13 to K13 , that is I13 J13 K13 by means of the formula "Yes" when the value is true.     

I'm working on excel and in one of the formulas I have to do, I calculate how many different items are associated with a specific ID. I have the following columns ID Item OPX-0020433077 Continuity Services OPX-0020433077...

I'm following an example of a Google page for the FILTER function and I get an ERROR but I do exactly the same thing as the examples, or at least I think so, to see if someone guides me. Here I leave the link of the Sheet: link And that...