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