Ask Your Question

Markc2265's profile - activity

2019-03-01 10:21:26 +0200 received badge  Popular Question (source)
2018-04-16 18:46:25 +0200 received badge  Famous Question (source)
2018-03-06 17:41:06 +0200 asked a question User-defined format for numbers being lost

User-defined format for numbers being lost I am trying to have time formats saved as H:MM A/P, but every time I save the

2018-03-05 21:57:59 +0200 commented question I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?

Thank you for reporting this error. It is very frustrating to work around it for the intended result.

2018-03-05 06:32:12 +0200 commented answer I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?

Thank you so much Lupp!!!! I really really appreciate your help. That spreadsheet example was very well done and was exa

2018-03-05 06:30:54 +0200 marked best answer I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?

Can someone please help with this problem?

2018-03-05 06:30:54 +0200 received badge  Scholar (source)
2018-03-05 01:44:43 +0200 received badge  Notable Question (source)
2018-03-04 13:32:33 +0200 received badge  Popular Question (source)
2018-03-04 04:26:58 +0200 received badge  Organizer (source)
2018-03-04 03:05:27 +0200 edited question I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?

I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,

2018-03-04 03:05:25 +0200 edited question I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?

I am trying to match the last non blank cell in a column with the header above it. I used this formula in Excel, =LOOKUP

2018-03-04 01:07:59 +0200 asked a question I am trying to match the last non blank cell in a row with the header above it. I used this formula in Excel, =LOOKUP(2,1/(L2:R2<>""),M$1:S$1) but its not working in LibreOffice. Any suggestions?

I am trying to match the last non blank cell in a column with the header above it. I used this formula in Excel, =LOOKUP