Results 1 to 5 of 5

Auto Fill Text With counting Function

Threaded View

Grimace Auto Fill Text With counting... 10-04-2010, 03:52 AM
snb Re: Auto Fill Text With... 10-04-2010, 04:23 AM
Grimace Re: Auto Fill Text With... 10-04-2010, 05:00 PM
snb Re: Auto Fill Text With... 10-04-2010, 05:08 PM
Grimace Re: Auto Fill Text With... 10-04-2010, 05:31 PM
  1. #1
    Forum Contributor Grimace's Avatar
    Join Date
    05-04-2009
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2013 and Office 365 Plus
    Posts
    380

    Auto Fill Text With counting Function

    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
    Attached Files Attached Files
    Last edited by Grimace; 10-04-2010 at 05:31 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1