none
Last Cell in Row RRS feed

  • Question

  • Hello Forum,

    I have a Range which the Row is fix (Row 5) and the Col ist variabel and I want to find the last Cell in Row5.  

    item  status 1 status 2
    1 55% 88%
    2 20% 30%
    3 30% 80%
    4 40% 70%
    5 50% 60%

    can anyone help please?

    Best regards,

    Thursday, April 12, 2018 7:35 AM

Answers

  • 1E+300 is a very large number: a 1 followed by 300 zeros: 1000...0

    If you use comma as decimal separator, the formula should be

    =LOOKUP(1E+300;5:5)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Req_En Wednesday, June 6, 2018 8:08 AM
    Thursday, April 19, 2018 7:48 AM

All replies

  • =LOOKUP(1E+300,5:5)

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Thursday, April 12, 2018 8:40 AM
  • Hello Hans,

    I tried with this Code but I get error!

    what mean 1E+300 here ?

    Best regards,

    Thursday, April 19, 2018 7:36 AM
  • 1E+300 is a very large number: a 1 followed by 300 zeros: 1000...0

    If you use comma as decimal separator, the formula should be

    =LOOKUP(1E+300;5:5)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Req_En Wednesday, June 6, 2018 8:08 AM
    Thursday, April 19, 2018 7:48 AM