Need help getting row count dependant on 2 variables

**s4driver** · 05-10-2013, 10:28 AM

Need help coming up with a script that will find the number of rows(related to invoices) for each vendor. Attached is a sample file that shows the how the data is formatted. Original data needs to stay intact, every thing is being return to a seperate tab. I need to get the row count starting from 3 rows down from each row that contains the text "Vendor" to the row before the row that contains " USD" or "--". The way I originally tried to get the count was like this

Please Login or Register  to view this content.

but it counts all the rows for the report.

vendor is defined like this

Please Login or Register  to view this content.

thanks in advance, s4

**DonkeyOte** · 05-12-2013, 01:00 PM

There are a number of approaches you could use here and I am not entirely sure you need code for this as it seems your data is fixed width, for ex.

Formula:

Please Login or Register  to view this content.

Using your sample the above would return 42.

**s4driver** · 05-13-2013, 08:38 AM

The goal is to build a database from a file similar to the sample file I attched. I am trying to write a macro that will accomplish that but I need a way to find how many records exist for each vendor so I can return the correct rows to the new database I am building.