Hello all

I am working on a project that has 30k+ lines and want to know if there is a formula I can use to keep me from having to go through all 30k lines of the document.

Hese is the situation at hand. A member can only have 12 'SERVUNITS' and those individuals that go over 12 need to be identified. I am attaching an example for review. As you can see, once I get to 12 SERVUNITS I am deleting everything after (see MEMBER 4). As you can see on the 3rd line this individual exceeded the 12 mark and everything over 12 has been subracted in the "UNITS OVER" column. Any help with this would be much appreciated.

Thanks

Attached Files

Book1.xlsx (15.6 KB, 12 views)

Does this help?

Crap it! I misread what you need!

Attached Files

CountMemberRows.xlsx (11.0 KB, 8 views)

Here are right formulas!

Attached Files

CountMemberRows.xlsx (11.6 KB, 12 views)

Hello
as you might suspect, the title of a thread is very important :
- for you because the more descriptive it is, the higher the chance you have to get help from one or many members. Most of us usually only check thread titles to see if the subject is part of our knowledge. You will admit that " Formula help" does not really " help".
- for others because when the thread is solved, they can profit from the answer to solve their own problems. The thread title can also be searched on the Net. You will admit that " Formula help" will not be searched for very often...

So, I would suggest, so that all can benefit from it, that you change your thread title to something more descriptive.
To do this edit your first post, click " go advanced" and there you can change your title accordingly.
Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks ArviLaanemets

This was very very helpful. I will still have to make the deductions over 12 manually, but at least I do not have to go through all 30k lines manually.

Thanks again

Simply add another column, where you enter the formula (I havent Excel at moment, and I don't remember ecact column headings)
NewQty = OldQty + Correction

If I remember correctly, the correction was negative.