Hi guys,

In order to create my program as efficient as possible. I’m wondering if there is a vb.net way to find the total amount an item excists in a column.

For example i have a column with over 200 different variations of numbers. And i need to know how many cells contain a certain number i’m searching for. With out iterating trough the entire column. Cause the data set is way to large to do this everytime.

The real life example is that i have a list with 100 application numbers. And i need to find the quantity that application is mentioned in a certain excel sheet. I already made a list of those application numbers to filter them out. But now i need to find a way to check how many times each list item excists in this large column.

To make this work with for each & if loops is not that hard. But this is a smal part of a verry large program i need to find a more efficient way to solve this. Hopefully vb.net has the anwser to this. But i can’t seems to find it.

If you guys have any suggestion dont hesitate to discuss them with me!

Thanks in advance.

Kind Regards,

JR