Auto Fill Text With counting Function

**Grimace** · 10-04-2010, 03:52 AM

Good evening

In the attached workbook, I am trying to write a function that will autofill the text in column B. However the text I need to fill is derived by a formula, in that it will mvary dependant on the input into Cell E1.

What I need to do is count the number of entries in column A .. easy enough.
I then need to divide this count by the number of Worklists in Cell E1. Easy again.

My problem is then filling the text in column B with the Wording "Worklist" and an even distribution of the Work between however many Worklists there are.

eg .. there are 30 rows of data, and 5 worklists ....
The top 6 rows will have worklist 1, the next 6 worklist 2 etc etc. to break down the rows evenly across the worklists

**snb** · 10-04-2010, 04:23 AM

in B1:
="Worksheet "&INTEGER(1+(ROW()-1)/$E$1)

**Grimace** · 10-04-2010, 05:00 PM

Thanks for the reply snb...

I tried this and it returned a column of #NAME? errors ?

Any ideas what may be causing this? I tried the help but it did not provide an outcome.

**snb** · 10-04-2010, 05:08 PM

Probably

="Worksheet "&INT(1+(ROW()-1)/$E$1)

**Grimace** · 10-04-2010, 05:31 PM

Awesome thank you

I then just had to swap the values in E1 and E3 and it gave me exactly the outcome I needed. I was probably unclear in my description.

thanks very much for your help, really appreciate it.