• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    On which occurrence John made his biggest sale?

    Hi all, It is from homework file in vlookup week, "getting the second matching value" article at chandoo website. I am having difficulty wrapping my head around this formula...
  2. N

    Array formula with INDEX, IF, SMALL and ROW functions

    I can't figure out how the array formula in second table (column "E") works. The basic idea is that only when you enter the quantity in first table (column B), that very item from column A appears in second table in column E. If you leave the quantity for item XYZ blank in the first table, item...
Back
Top