Search results

@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!

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

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

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