locked
Look upper and under row RRS feed

  • Question

  • Number OS Time
    300000067778 0010 15,000
    300000067908 0010 9,000
    300000067913 0010 4,500
    300000068081 0010 1,500
    300000068101 0010 6,670
    300000068299 0020 11,830
    100000160053 0010 5,000
    100000160339 0020 13,000

    I have this excel file, When I execute a "New Column" function I need to know if the previous and next rows (from OS column) is distinct from my row. I'm trying to do it but i cant figure out.


    Wednesday, January 14, 2015 7:16 PM

Answers

  • You can also check this article by Ken Puls. He describes how to refer to the next row in Power Query.
    View article...

    Regards,


    Thursday, January 15, 2015 9:28 AM

All replies

  • Hi,

    I don't clear question. Any way, I have made a sample file as my understand. I don't know whether is correct or not.

    https://onedrive.live.com/edit.aspx?cid=94B99C319E63236A&resid=94B99C319E63236A%21342&app=Excel

    I hope this help you.

    Regards,

    Thursday, January 15, 2015 2:33 AM
  • You can also check this article by Ken Puls. He describes how to refer to the next row in Power Query.
    View article...

    Regards,


    Thursday, January 15, 2015 9:28 AM
  • Hi,

    You can watch my video about something similar (index + n or index - n) if you want :-)

    https://www.youtube.com/watch?v=wQCLCazJFjY

    or 3rd part of this video.

    I did not know that this technique is unknown.

    Thursday, January 15, 2015 12:37 PM