• 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. E

    How do I pull data from a long, long list?

    @bobhc I'm using excel 2008. I didn't have the insert>table function? All I have is Data>table, and even then I don't understand how the input row is supposed to be working. Anyway, I'll read up on it later. Thanks everyone!
  2. E

    How do I pull data from a long, long list?

    Thanks Narayank991! It's working! But can you help me by explaining the logic behind the formula? From what I see, it uses the index and match function just like vijay.vizzu suggested. But how do you select the data to be indexed and matched? @bobhc can you explain how to do that too? I'm...
  3. E

    How do I pull data from a long, long list?

    Thanks for the reply everyone! Here is a sample of the list: https://www.dropbox.com/s/3a1xjoppjnbqyzp/sample.xls I've just taken a short sample list. The original is much longer than that, unfortunately. So what can I do, so that when I type the serial number at a fresh excel...
  4. E

    How do I pull data from a long, long list?

    Hi everyone, I was just wondering is there a simple way to pull rows of entry from a large list. So I have this long lists of a product. The list consists of the product's serial number, and its test results (It's the same product). This list is a product certificate from the factory, that the...
Back
Top