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, 14 views)