1

Excel – Prikaži vrijednost zadnjeg retka u stupcu S; prikaži vrijednost zadnjeg stupca u redu 19

written by js | 2023-08-08
  • =LOOKUP(2;1/(NOT(ISBLANK(S:S)));S:S)
  • =LOOKUP(2;1/(NOT(ISBLANK(19:19)));19:19)

excel xexcel xlsx xxlsx last row in a column xrow xcolumn xzadnji xredak xstupac stupac