Count Rows

[PhilH1982]

Seems I'm on here nearly every day now.

In the workbooks that I'm working on, I have a sheet which counts the number of staff we have, the amount of work we have, how much each member of staff should ideally have on their alpha split, and how much work they actually have.

Is it possible for a formula which when the formula returns the amount of customers they are responsible for, counts that amount of rows to show what customers they are responsible for, starting cell A2.

Eg. Me = 247 cases

So my suggested work split should be.

Cell A2 = Abbott
Cell A248 = Andrews

Then the next person would count the number of cells of their worksplit from A249. I'm not sure that its possible, but you guys always seem to find a way.

Thanks.

[daddylonglegs]

Assume your name is in C2 and the number of cases you have (247) in D2, all other staff names and the number of cases for each in C3 down and D3 down, then in E2 use this formula copied down

=INDEX(A$2:A$10000,SUM(D$2:D2))

[PhilH1982]

Thanks that works fantastic. Impressed my boss!! (which I did mention was with help).

Next challenge for me (and maybe if you can help) is the list of customer names is split over 3 books. So it might suggest that my split ends later but the person following me who is on the next book, it will only show the end split on their own book.