Mrrrr's Forum
Lista Forumurilor Pe Tematici
Mrrrr's Forum | Lista de useri | Inregistrare | Login


Nu sunteti logat.
Nou pe simpatie:
25 ani
cauta Barbat
25 - 50 ani
Mrrrr's Forum / Tutoriale si Ghiduri Utile // Tutorials and useful guides / [EXCEL] Get Value of Last Non Empty Cell in Row [LOOKUP] Moderat de TonyTzu  
Mesaj Pagini: 1
Membru activ

Inregistrat: acum 1 an
Postari: 308
Source: ... empty-cell


It does not have to be an entire column, you can make the formula like:


pus acum 1 luna
Membru activ

Inregistrat: acum 1 an
Postari: 308
Same source as above, all credit to them.

Dealing with errors

If there are errors in the lookup_vector, particularly if there is an error in the last non-empty cell, this formula needs to be adjusted. This adjustment is needed because <>"" criteria will return an error itself if a cell contains an error. To workaround this problem, use ISBLANK with NOT:


Last numeric value

To get the last numeric value, you can add the ISNUMBER function like this:


Position of the last value

If you want to get the position (in this case row number) of the last value, you can try a formula like this:


Here we feed the row numbers of the same range into lookup for the result vector and get back the row number of the last match.

pus acum 1 luna
Pagini: 1    
Mergi la