Automate True-False Test on Long Column of Company Data

Hi

The attached worksheet is an example of a larger worksheet that contains the expenses for 3000+ companies. The columns represent the following categories: A(record number); B(organizational number); C (line number representing specific expense categories; D (salary ( line 100) and non salary (line 200) expenses); E Item value. The companies report up to 100 lines of data identified as lines 1-100. The last two lines, 101 salary and non-salary expenses end the data for each company. Each company reports salary and non-salary expenses for each line item; not all companies report every line or every category. I have used the true-false test =sum(E1:E100)=(E101:101) manually for smaller worksheets. I would like to automate this formula in some sort of a drag down fashion to run the test on a much larger worksheet.
Thank you for taking the time to read and consider this query.

Al

Hi

Thanks for responding. Sorry for not being clear with my query. In the first company 660004 there is not 100 entry. Row 93 and 94, however, are the first examples of the 101 entries and the true-false statement that I mentioned in my query.

I'll take a look at the pivot table reference but I am an Excel newbie so I am not, unfortunately, not very efficient with new approaches.

Does my identifying the 101 help with a recommendation?

Thanks

Al

Good Evening.

Thanks for responding to my inquiry.

I just got on line and ran a few tests. It seems to work fantastically. I'll try some more tests in the morning.

In the mean time, thanks again.

I sure wish I could understand more of how one can learn to create these formulae?

Thanks

Al